Combining a few columns into one --can I nest IF statements?

My current formula is

=IF([To whom will the sample go?]@row = "Customer/Shipped out", "Shipping Date: " + [Date to be Shipped]@row + CHAR(10) + [Ship Method]@row + CHAR(10) + CHAR(10) + [TR Full Contact Info]@row , "")

I need this to be able to look at [TR Full Contact Info]@row and if blank, pull the information from [IN Full Contact Info]@ row

AI recommended :

Use IF(ISBLANK([TR Full Contact Info]@row ), [IN Full Contact Info]@row , [TR Full Contact Info]@row ) in your formula to select the correct contact info.

I tried subbing this in the one above for the [TR Full Contact Info]@row in the first formula but it didn't work:

=IF([To whom will the sample go?]@row = "Customer/Shipped out", "Shipping Date: " + [Date to be Shipped]@row + CHAR(10) + [Ship Method]@row + CHAR(10) + CHAR(10) + IF(ISBLANK([TR Full Contact Info]@row), [IN Full Contact Info]@row, [TR Full Contact Info]@row ) , "")

Any help appreciated!

Thanks

Tammy

Find more posts tagged with

Accepted answers

All comments

jmyzk_cloudsmart_jp

@Tammy D

I don't see any problem with your formula.

I came up with the same one.

=IF([To whom will the sample go?]@row = "Customer/Shipped out", "Shipping Date: " + [Date to be Shipped]@row + CHAR(10) + [Ship Method]@row + CHAR(10) + CHAR(10) + IF(ISBLANK([TR Full Contact Info]@row), [IN Full Contact Info]@row, [TR Full Contact Info]@row), "")

Didn't you forget to use the Wrap menu?

https://app.smartsheet.com/b/publish?EQBCT=ba2959e3af68455fb1d02d133a2f993f

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, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.