Can you have two countif formulas in one cell?
I created a quiz in forms, and I am trying to capture all the right answers in the row to one cell. I have 7 questions each in their own column. When I try to use the countif formula to capture if the answer to question one is right it works and puts a 1 in the questions right column. When I go to add another formula two capture the right answer for question 2 it wont let me do it. Is there a formula to capture each right question in the same cell for that row? Essentially, I need it to capture all the right answers in the row in my Questions Right for that row.
Answers
-
I hope you're well and safe!
Add a + between the COUNTIF.
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
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.
-
That did not work, or I could have put it in wrong. Do I just put a plus sing between "and" and the second countif? Or clear the "and" and put the + sign instead? I tried it both ways and it did not work.
-
Try something like this. (replace with your own column names)
=COUNTIF([In Stock?]:[In Stock?], 1)+COUNTIF([In Stock?]:[In Stock?], 1)
Did it work?
✅Remember! 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.
-
That worked thank you for your help. I appreciate it!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 61.6K Get Help
- 327 Global Discussions
- 185 Industry Talk
- 421 Announcements
- 4.3K Ideas & Feature Requests
- 129 Brandfolder
- 127 Just for fun
- 124 Community Job Board
- 443 Show & Tell
- 27 Member Spotlight
- 1 SmartStories
- 279 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!