Adding Condition to IF Statement

Akrenn12 · 04/19/23

Hello!

I have a smartsheet setup that is collecting data for an asset library. Part of the data is to assign ID numbers when specific values are met. I have 3 columns, I have a stock ID column that is populated manually with tock IDs. Then I have an internal ID column that is auto-populated via smartsheet when the stock ID is left blank. Both these columns feed into the Master ID column using this formula: =IF([Stock ID]@row <> "", [Stock ID]@row, [Internal ID]@row])

This formula is working as it should, however I need to add another condition if possible.

I have another row called 'Asset Type'. If an asset is 'Reused Asset' then I want the Master ID column to be left blank so that our developers can add in the ID from the reused asset. Is this possible?

Here is a screenshot to show the rows I am talking about:

Amber Eakin · 04/19/23

Give this a go:

=IF([Resource Type]@row = "Reused Asset", "", IF([Stock ID]@row <> "", [Stock ID]@row, [Internal ID]@row))

Amber Eakin · 04/19/23

Certainly,@Akrenn12! You can nest the IF statements. Give this a try.

=IF([Resource Type]@row = "Reused Asset", "", IF[Stock ID]@row <> "", [Stock ID]@row, [Internal ID]@row])

Please let me know if that helps!

Akrenn12 · 04/19/23

@Amber EakinThank you for the reply. This new formula did not work, unfortunately. It comes up #UNPARSEABLE

Amber Eakin · 04/19/23

Give this a go:

=IF([Resource Type]@row = "Reused Asset", "", IF([Stock ID]@row <> "", [Stock ID]@row, [Internal ID]@row))

Akrenn12 · 04/19/23

@Amber EakinIt works! I need to add an asterisk before the Resource Type, as that is how I have it as the heading in my sheet. I think that was the issue!

Thank you!

Amber Eakin · 04/19/23

You're welcome!

Adding Condition to IF Statement

Best Answer

Answers

Help Article Resources

Categories