Formula Help
Hi,
I am trying to combine two formulas into one, both, are correct on their own but I am unsure on how to combine them.
Formula1: =IF([% Complete]7 < ABS(0.6), "High", "Low")
Formula2: =IF(Blocked7 = 1, "High", "Low")
So, if either of the "BOLD" conditions above are satisfied, then I would want the true/false values to return in the formula cell.
Thank you!
Comments
-
Woohoo, I answered my own question.
Solution: =IF(OR(([% Complete]7 < ABS(0.6)), Blocked7), "High", "Low")
-
try this
=if(or([% Complete]<ABS(0.6),Blocked7=1),"high","low")
I'm not sure what the ABS cell is representing, but just make sure that your <,>,= symbols are used correctly in the formula.
-
Hi all,
Respectfully, I'd go with:
=IF(OR([% Complete]<0.6,Blocked7),"Hi","Low")
You don't need to specify criteria when referencing checkboxes in an IF statement and the ABS is doing nothing at all because you're already specifying a positive value. You'd only use ABS if you were referencing a value that could be + or - and you wanted to deal with the value as an absolute (i.e. positive) number.
Cheers,
Chris
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 405 Global Discussions
- 216 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!