I need help with a IF formula, how to return a value and ignore rest of formula if a box is checked?
I have a formula started in the Day 1 Delay column to return various values if the duration of delay is between certain numbers however, if the on hold or cancelled columns are checked. I'd like a value to be returned, I'm assuming it would need to ignore the formula is the box is checked and only return "On hold" or "Cancelled" in the Day 1 delay column. Thoughts on a formula?
Best Answer

Since the Cancelled or On Hold columns are the first consideration in your statement, start your if off with this check.
If(OR(Cancelled@row=1,[On Hold]@row=1),'Your Value if True', 'Your Formula here if False')
Answers

Since the Cancelled or On Hold columns are the first consideration in your statement, start your if off with this check.
If(OR(Cancelled@row=1,[On Hold]@row=1),'Your Value if True', 'Your Formula here if False')

This worked, thank you!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.1K Get Help
 351 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 133 Brandfolder
 127 Just for fun
 127 Community Job Board
 443 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!