IF Function

nlarson_PMC
nlarson_PMC ✭✭
edited 01/18/22 in Formulas and Functions

I'm trying to create a Function where, if the status column is marked as "Completed" then the checkbox in the done column is activated. I'm not quite sure how to do that, can anyone help?

Best Answer

  • ChloeSmith
    ChloeSmith ✭✭✭✭
    Answer ✓

    I think you'd want to use automation for this. The "Change Cell Value" automation could change the checkbox to checked once the status column is marked as completed. Does that help?

Answers

  • ChloeSmith
    ChloeSmith ✭✭✭✭
    Answer ✓

    I think you'd want to use automation for this. The "Change Cell Value" automation could change the checkbox to checked once the status column is marked as completed. Does that help?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!