Formula Help

Stephanie Taylor
Stephanie Taylor ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Hello Everyone,

I am looking for a formula that will place a number in column B if Column A has a check box that is checked.

Thanks in advance.




  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    =IF([Column A Title]23 = 1, 3000) 

    Put this formula in Column B and replace Column A Title with the actual column name. And change the row 23 - to whatever row number it is.  Then change the number 3000 to whatever number you want. 

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!