Using a Flagged Column to fill in a Cell

Todd Smelser

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

Screen Shot 2021-05-20 at 10.36.57 AM.png

To be clear, I am using =IF(Done@row = 1, "Complete") now but that wipes out the other entries (In Progress, etc.)

Paul Newcome

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"))

Paul Newcome

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

Paul Newcome

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

Todd Smelser

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"

Paul Newcome

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"))

Todd Smelser

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

Paul Newcome

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

Todd Smelser

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

Paul Newcome

Happy to help. 👍️

Todd Smelser

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

Paul Newcome

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.