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

You would do somethign like this:
=IF([Range_Complexity]@row = "Complex", formula_if_true, formula_if_false)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Answers

You would do somethign like this:
=IF([Range_Complexity]@row = "Complex", formula_if_true, formula_if_false)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am  12:45pm!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.9K Get Help
 379 Global Discussions
 210 Industry Talk
 441 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 300 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!