Multiple "Then" in an If then formula

Tony DiPaolo

Hello,

Does anyone know if it is possible to have multiple "Thens" in a If/Then formula?

I have a column with a multi-select drop down for new hire provisioning needs, and we want to automatically pre-populate the Software column with 2 applications everyone will need and then still allow hiring managers to add more to that column through an update request. I would like to write: If(Status1="Hired",[Word, Acrobat Reader],""), so if status changes to "Hired" Word and Acrobat Reader are automatically added in the cell of the Software column. Can this be done without being forced to write the 2 applications as one item "If(Status1="Hired" , "Word, Acrobat Reader" , "")?

L_123

you want the text

Word, Acrobat Reader

to be added to the cell, or do you want to add the values in columns named word and acrobat reader? Or do you want the values to be on different lines?

This will add the values from columns named word and acrobat reader with a comma and space in between

[Word]@row + ", " + [Acrobat Reader]@row

This will add the text with a carriage return between them (you need to text wrap the cells for this to work properly)

"Word" + Char(10) + "Acrobat Reader"

You can mix and match these as you like, just stick them in your existing if statement to add the conditional logic.

Andrée Starå

Hi @Tony DiPaolo

Unfortunately, it's not possible at the moment because they can't update a cell with a formula in it, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could maybe use so-called helper columns. One for the main values and another for the added values, and then we would combine them in another column.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

L_123

you want the text

Word, Acrobat Reader

to be added to the cell, or do you want to add the values in columns named word and acrobat reader? Or do you want the values to be on different lines?

This will add the values from columns named word and acrobat reader with a comma and space in between

[Word]@row + ", " + [Acrobat Reader]@row

This will add the text with a carriage return between them (you need to text wrap the cells for this to work properly)

"Word" + Char(10) + "Acrobat Reader"

You can mix and match these as you like, just stick them in your existing if statement to add the conditional logic.

Andrée Starå

Hi @Tony DiPaolo

Unfortunately, it's not possible at the moment because they can't update a cell with a formula in it, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could maybe use so-called helper columns. One for the main values and another for the added values, and then we would combine them in another column.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tony DiPaolo

Thank you L@123 and Andree. I will use the formula to add the items on separate rows within a cell, create a helper column for the rest of the software to be added through the Update Request as submit an enhancement request to Smartsheet. Thank you for the quick answers.

Andrée Starå

@Tony DiPaolo

Excellent!

You're more than welcome!