Adding Condition to IF Statement


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:

Best Answer

  • Amber Eakin
    Amber Eakin ✭✭✭✭✭✭
    Answer ✓

    Give this a go:

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

    Amber Eakin, MSLS, M.Ed.

    Adult Education Specialist | Process Improvement Enthusiast


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!