Using a Flagged Column to fill in a Cell
Hi all,
Is it possible to create a formula that would complete a STATUS column when a flagged cell is activated (Like a checkbox). In the attached example, I would like to automatically fill in the Complete Status when the check box is TRUE in the DONE column
To be clear, I am using =IF(Done@row = 1, "Complete") now but that wipes out the other entries (In Progress, etc.)
Best Answers

You would need to first establish the logic for "In Progress" and "Not Started". Then you can use a nested IF formula.
=IF(Done@row = 1, "Complete", IF(logic_for_not_started, "Not Started", "In Progress"))

The second "@row". It should be all lowercase, but you have a capital "R".
Answers

You would have to either automate all of the different options for statuses or you would have to keep it all manual.

I can do that if I know what the complete Syntax is for the formula. I would need to know how to express "If(Done@row=0), "In Progress, "Not Started"

You would need to first establish the logic for "In Progress" and "Not Started". Then you can use a nested IF formula.
=IF(Done@row = 1, "Complete", IF(logic_for_not_started, "Not Started", "In Progress"))

Thank you , as always, Paul. I seem to now have a syntax error someplace.
=IF(Done@row = 1, "Complete", IF(Done@Row=0, "Not Started", "In Progress"))
Returns, "UNPARSABLE"
Guessing that I cannot have two criteria in a single argument

The second "@row". It should be all lowercase, but you have a capital "R".

You are a Stud, my friend! It's always the stupid things with me....


Interesting note; Making this a Column formula removes the drop down. Need to keep it as a cell formula.

Yes. That is because when it is applied as a column formula, the cell cannot be manually edited. This is true for column formulas in all column types.
Help Article Resources
Categories
Check out the Formula Handbook template!