How do I mark a row complete based on answers from another cell?
I have a cell called Bucket with 6 possible options(Needs Review, Not Doing, Easy to Do, Should Do Needs Comms, Done) and want the status field to mark complete if the cell is anything but Needs Review
I tried =IF([Bucket]1 "Not Doing" = "Complete") just to make one work that was marked as Not Doing as a start but on the cell I tried it in that didn't work. Any suggestions?
Best Answers
-
Try, =IF(Bucket@row <> "Needs Review", "Complete", "Needs Review")
-
However, if you add a formula to the status field, you can't also have the status field be manually changed as well. Any manual changes will overwrite your status field.
Answers
-
Try, =IF(Bucket@row <> "Needs Review", "Complete", "Needs Review")
-
However, if you add a formula to the status field, you can't also have the status field be manually changed as well. Any manual changes will overwrite your status field.
Help Article Resources
Categories
Check out the Formula Handbook template!