Combining formulas
Hi,
I need some help with a formula. I have a one check mark column that I would like to 'check' if any of the following formulas are true. Can I combine them into one large formula?
=IF(AND([Key Activity]@row, 1, [CEC Tech]@row, 1), 1)
=IF(AND([Key Activity]@row, 1, [Corp iT]@row, 1), 1)
=IF(AND([Key Activity]@row, 1, Digital@row, 1), 1)
=IF(AND([Key Activity]@row, 1, Loyalty@row, 1), 1)
=IF(AND([Key Activity]@row, 1, [L+D]@row, 1), 1)
I would appreciate any assistance that you can offer.
Thank you!
Best Answer
-
=if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,Digital@row,Loyalty@row,[L+D]@row),1
I think that should do it. you might be able to get it shorter depending on how the sheet is organized, but I can't tell without seeing the sheet. If you want to try you can post a picture of the sheet blurring out any personal info and I would be happy to try.
Answers
-
=if([Key Activity]@row,if(or([CEC Tech]@row,[Corp iT]@row,Digital@row,Loyalty@row,[L+D]@row),1
I think that should do it. you might be able to get it shorter depending on how the sheet is organized, but I can't tell without seeing the sheet. If you want to try you can post a picture of the sheet blurring out any personal info and I would be happy to try.
-
Thank you! It works perfectly.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K 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
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!