How do I create an IF for a line of cells that if true picks multiple values from cells?
fruiz
✭✭
Hi, I'm trying to do this elegantly
=SUM(IF(E7:U7="x";value1 for E7, value2 for F7, value3 for G7...;0)
Can it be done?
Answers
-
Hey @fruiz
Can you share some screenshots and more info?
Itai Perez
If you found my comment helpful any reaction, Insightful, Awsome etc... would be appreciated🙂
https://www.linkedin.com/in/itai-perez/
-
Yes, each of those cells it's a checklist of elements with a cost assigned in other cells that are added up in the cell in the right. the cell in the right should be a a formula that sums all the elements checklisted with an x
Right now the formula looks like this and works but i'm guessing there is a better way to do it
-
lol sorry i thought this was an excel forum...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 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!