How do I create an IF for a line of cells that if true picks multiple values from cells?
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
Reporting and Project Manager
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
-
Hi @fruiz
It looks like these screen captures are in Excel and not in Smartsheet. Are you able to share a screen capture of your Smartsheet sheet with the column names showing?
Thanks!
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
lol sorry i thought this was an excel forum...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 360 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!