Formula Question
Good morning, I'm fairly new to Smartsheet, and before coming here I did some research in the community and the formulas and functions page, I have not been able to figure out how to do (it may not even be possible), hope to get some clarification at least, so thank you in advance!
Looking at two column rows, and if one or both of them = No then to display 0 (Zero). I'm able to do per single column but not both columns, I have tried changing the 0 (Zero) to No and still get the same error?
I have tried =IF(OR and =IF(AND
Working on single row (=IF([Authn 2]@row = "No", 0)
Error when adding the second row #INCORRECT ARGUMENT SET
Tried:
=IF(AND([Authn 2]@row, [Provided Accurate Info 10.1]@row = "No", "0")
=IF(OR([Authn 2]@row, [Provided Accurate Info 10.1]@row = "No", "0")
**I have a sheet that has 17 columns and is column 1 and 16 = No then column 17 = 0 (Zero)
Please le me know if you have any questions.
Answers
-
Hey @cruzmike ! The formulas you've tried are very close, you just need to adjust the parameters slightly so both entries in the OR statement are set up as logical tests. Try this:
=IF(OR([Authn 2]@row = "No", [Provided Accurate Info 10.1]@row = "No", "0")
This formula will return "0" if either of the columns are equal to "No".
Let me know if you're still having trouble, I'm happy to help some more if you need it! 😊
-
-
Hi @cruzmike
I hope you're well and safe!
Try something like this.
=IF(OR([Authn 2]@row = "No", [Provided Accurate Info 10.1]@row = "No"), 0)
Did that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Good morning, @Andrée Starå , that did it, thank you! and thank you at everyone that chimed in, I have been trying to find a solution for a while, you guys ROCK!
You all have a great weekend.
-
Excellent!
Happy to help!
✅Please support the Community by marking the post(s) that helped or answered your question or solved your problem with the accepted answer/helpful, Insightful/Vote Up/Awesome. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!