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!
Solved! Go to Solution.
Thank you so much!