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?

· Share on FacebookShare on Twitter

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?

    · Share on FacebookShare on Twitter

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?

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!