Can you combine if and or formulas
Here is the formula that I currently have and works great currently:
=IF(COUNTIFS({UCA App E#}, [E #]@row, {EPU approved}, true) > 0, true, false)
First is the match the text in "UCA app e#" and "E #", but also needs "EPU approved" which is a checkbox, to be 'checked'. I need to add a second field that is a check box to also bring back true if 'checked'.
So the logic would be, IF a match to the text in E# field is yes, AND either "EPU approved" OR "logged for future" is checked, then bring back the value of true (also a checkbox).
Best Answer
-
Hi @Nate Ensor
Looks like you're missing a > sign before the second 0, and the "true" / "false" statement at the end.
Try this:
=IF(OR(COUNTIFS({UCA App E#}, [Entegra E #]@row, {EPU approved}, true) > 0, COUNTIFS({UCA App E#}, [Entegra E #]@row, {approved for future}, true) >0), true, false)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Answers
-
@Nate Ensor You could wrap a couple CountIFs in an or() .
OR(COUNTIFS({UCA App E#}, [E #]@row, {EPU approved}, true) > 0 , COUNTIFS({UCA App E#}, [E #]@row, {logged for future}, true) >0)
Then put that in your IF statement logic expression
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
ok I gotcha. Makes sense, countifs match listed twice combined with the true statement for both other columns.
I still can't quite put it together though, I'm missing something or it's getting late lol...but I'm getting the unparseable error. Not as simple as just putting "IF" at the beginning?
=IF(OR(COUNTIFS({UCA App E#}, [Entegra E #]@row, {EPU approved}, true) > 0, COUNTIFS({UCA App E#}, [Entegra E #]@row, {approved for future}, true) 0))
-
Hi @Nate Ensor
Looks like you're missing a > sign before the second 0, and the "true" / "false" statement at the end.
Try this:
=IF(OR(COUNTIFS({UCA App E#}, [Entegra E #]@row, {EPU approved}, true) > 0, COUNTIFS({UCA App E#}, [Entegra E #]@row, {approved for future}, true) >0), true, false)
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 287 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!