Finding a value in a column and creating another column based on that value

[vanorve]

Hello, Community!

I currently have a column called NOLs Generated. It typically includes only numeric values: 

NOLs Generated

1000

2000

3000

However, sometimes, the column will include text among the numeric values, as in the following: 

NOLs Generated

1000

TBD

2000

3000

TBD

I want to write a formula/figure out a way to scan the NOLs Generated column. What I want is as follows: (1) if the NOLs Generated column includes "TBD", then I want to create another column called "Draft_Final" that is filled, top to bottom, with the text "Draft".

If, on the other hand, (2) the NOLs Generated column does not include "TBD", then I want to create another column called "Draft_Final" that is filled, top to bottom, with the text "Final." Please see below:

(1) Draft_Final

      Draft

      Draft

      Draft

or

(2)

      Draft_Final

      Final

      Final

      Final

Can someone please help? I've been trying to figure out the best approach for some time now. Thank you in advance!

[RolandSchubert · Accepted solution]

Hi,

a simple approach could be to filter the rows containing "TBD", count the number of rows, append the count to the rows and create a formula setting a new field to either "Draft" or "Final".

Sample workflow is attached. Hoefully this is helpful

Best regards

Roland

[vanorve]

Thank you so much!