I am trying to set up an at IF statement -

if a box is checked, then enter 100% in the %Completed column??

Best Answer

  • Jason Duryea
    Jason Duryea ✭✭✭✭✭✭
    Answer ✓

    The formula would have to go in the % Complete column, which would prevent someone from manually entering any other % in the cell.

    To avoid this, setup an automation to change a cell value when the checkbox is checked instead.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!