Formula Help

Options
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.

 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    =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. 

    · 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!