How can I create an IF(AND formula with multiple check box columns
newtothis
✭✭
I want to create a formula as below, I know this will more than likely be a large formula and that's ok! Almost all of these columns will be check boxes with the exception of 1!
So far I have:
=IF(Quote@row = 1, "AAV", (IF(AND(Quote@row = 1, EmailSent@row = 1, "AST")))
Now how can I add to the formula if a column isn't blank to return the value that is not a checkbox?
Best Answer

I actually solved this myself! I created a helper column for the one column that was not a check box!
Answers

I actually solved this myself! I created a helper column for the one column that was not a check box!

Hi @newtothis!
Glad you worked it out! Thank you for sharing your solution!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.7K Get Help
 63 Global Discussions
 69 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 464 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!