Adding Condition to IF Statement

Akrenn12

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

Give this a go:

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

Amber Eakin

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

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

Amber Eakin

Give this a go:

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

Akrenn12

@Amber Eakin It 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

You're welcome!