Adding Condition to IF Statement

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:

Find more posts tagged with

Integrations

functionality

Automations

Cell linking

Accepted answers

Amber Eakin

Give this a go:

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

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.