Using a Flagged Column to fill in a Cell
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.)
Help Article Resources
Check out the Formula Handbook template!