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

  • Itai Perez
    Itai Perez ✭✭✭✭✭✭

    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/

  • fruiz
    fruiz ✭✭
    edited 09/12/23

    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 for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

  • fruiz
    fruiz ✭✭

    lol sorry i thought this was an excel forum...

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!