Smartsheet formula

David Clunie · 05/23/22

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

Paul Newcome · 05/23/22

You would do somethign like this:

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

Paul Newcome · 05/23/22

You would do somethign like this:

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

Best Answer