Smartsheet formula
Options
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

You would do somethign like this:
=IF([Range_Complexity]@row = "Complex", formula_if_true, formula_if_false)
Answers

You would do somethign like this:
=IF([Range_Complexity]@row = "Complex", formula_if_true, formula_if_false)
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!