+1Hello,
I’m bringing in my data into my Excel as middleware file and would like to add a column with a formula. Ofcourse there is no data in my file before running the report, so the #N/A appears in the column.
My excel as middleware file:
My Result was the same:
How do I create a formula in the excel as middleware file?
Best answer by Chris_Ben
Hi Seth, here’s an Excel formula that you can use instead of TEXTAFTER:
=RIGHT(C2,LEN(C2)-FIND(": ",C2,1))
+12Hi
Currently we only support Excel Office 2016 formulas. So the TextAfter was applied in Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4
We have an Idea post here: https://ideas.nintex.com/ideas/IDEA-I-4293
You can upvote and post on the thread and our Product Manager will be notified and may be able to provide more road map ETA details of a newer office version
sorry for the inconvenience and hope there is an alternative formula for the TextAfter
Brent
+14Hi Seth, here’s an Excel formula that you can use instead of TEXTAFTER:
=RIGHT(C2,LEN(C2)-FIND(": ",C2,1))
+1Hi
that works for the first row, but subsequent rows look like this:
The formula doesn’t update to the next row. I’m thinking there has to be a table field reference.
Do you know how to update the formula to the next cell?
Thanks!
+14Hi Seth,
This is an Excel question rather than a Nintex one but I’d expect you should be able to copy cell D2 and paste into all the rows below that and the formula will update to reference the respective row.
Cheers,
Chris
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
