Using a Flagged Column to fill in a Cell

Todd Smelser
Todd Smelser ✭✭
edited 05/20/21 in Formulas and Functions

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!