Set a Checkbox Based on Color Status from Another Sheet


I'm trying to set a checkbox on sheet 1 based on the color status in sheet 2. For example, if the status on the 2nd sheet is "Blue," I want to check the box on sheet 1. Here is my formula:

=IF({Overall Completion} = "Blue", 1)

However, that generates a #INVALID OPERATION

Any suggestions?

Best Answer


  • Geoff Hill

    Thanks Genevieve! The cell-link idea worked!

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Geoff, that's great! Thanks for letting us know. 🙂

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!