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?

Itai Perez

Hey @fruiz

Can you share some screenshots and more info?

fruiz

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

Genevieve P.

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

fruiz

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