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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!