Formula

Options
Tishm
Tishm ✭
in Formulas and Functions

I want to add 10 weeks to the date in column 1 if the text in column 2 equals smart

· Share on FacebookShare on Twitter

Answers

  • Protonsponge
    Protonsponge Community Champion
    edited 03/11/25

    Hello @Tishm,

    Would the following work for you - IF [Column2] equals "Smart" then [Column1] plus 70 days.

    =IF([Column2]@row = "Smart", [Column1]@row + 70, "")

    image.png

    I hope that is helpful to you in someway,

    Protonsponge

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