Smartsheet formula

Hi, Some help would be great if possible, I need to get this working on an if statement if possible.

I need it to look for a [Range_Complexity]@row called "Complex" and if so change the formula to this

=WORKDAY([Lock Off (Online -6 Weeks)]@row, -DRCOUNTCOMPLEX#, {Holidays Range 3})

Std Formula if it does not find the word "Complex"

=WORKDAY([Lock Off (Online -6 Weeks)]@row, -DRCOUNT#, {Holidays Range 3})


Thanks in advance

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would do somethign like this:


    =IF([Range_Complexity]@row = "Complex", formula_if_true, formula_if_false)

    thinkspi.com

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would do somethign like this:


    =IF([Range_Complexity]@row = "Complex", formula_if_true, formula_if_false)

    thinkspi.com