IF Function

Baylie Brown
Baylie Brown ✭✭
edited 12/07/20 in Formulas and Functions

If a cell in column B says 10-25, how can I make a cell in column C say 1 hour?


  • Ramsay Zaki
    Ramsay Zaki ✭✭✭✭✭✭

    Need more information as to what you are trying to do. What does 10-25 represent (is that a date?). How does 10-25 = 1 hour?

    Without knowing more, I'd say to do what you want is as follows:

    IF([column name]@row = "10-25", "1 hour", "")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!