Multiple IF conditions

KempenUSA

I need help with the IF function in a string based on multiple selections in a cell.

I need the formula to have difference values based on users selecting multiple items in a cell.

Follow is my attempt at the formula, but clearly not working:

=IF(HAS([RESOURCES]@row, "RESOURCE 1"), 1), IF([RESOURCES], "RESOURCE 1", "RESOURCE 2"), 2), IF([RESOURCES], "RESOURCE 1", "RESOURCE 2", "RESOURCE 3"), 3))

Image of the Smartsheet:

RESOURCES	TOTAL SHTS
RESOURCE 1 RESOURCE 2 RESOURCE 3

The formula should result with the following:

IF ONLY RESOURCE 1 IS SELECTED - THEN TOTAL SHEETS = 1

IF RESOURCE 1 AND 2 IS SELECTED - THEN TOTAL SHEETS = 2

IF RESOURCE 1, 2 AND 3 IS SELECTED - THEN TOTAL SHEETS = 3

Most probably pretty straight forward, but you never know!

Nick Korna

Hi @KempenUSA

Is your RESOURCES column a dropdown that allows multiple selections? If so, you can use something like this:

=IF(COUNTM(Resources@row) = 1, 1, IF(COUNTM(Resources@row) = 2, 2, IF(COUNTM(Resources@row) = 3, 3)))

Alternatively if your resources are sequential (e.g 3 is never picked without 1 & 2, and 2 is never picked without 1) then you could use something like this:

=IF(HAS(Resources@row, "Resource 3"), 3, IF(HAS(Resources@row, "Resource 2"), 2, IF(HAS(Resources@row, "Resource 1"), 1)))

Hope this helps, but if you've any problems/questions then just let us know!

Nick Korna

Hi @KempenUSA

Is your RESOURCES column a dropdown that allows multiple selections? If so, you can use something like this:

=IF(COUNTM(Resources@row) = 1, 1, IF(COUNTM(Resources@row) = 2, 2, IF(COUNTM(Resources@row) = 3, 3)))

Alternatively if your resources are sequential (e.g 3 is never picked without 1 & 2, and 2 is never picked without 1) then you could use something like this:

=IF(HAS(Resources@row, "Resource 3"), 3, IF(HAS(Resources@row, "Resource 2"), 2, IF(HAS(Resources@row, "Resource 1"), 1)))

Hope this helps, but if you've any problems/questions then just let us know!

KempenUSA

@Nick Korna Works perfect, Thank you!