Data Shuttle Input Expressions and Symbols

I added this formula to an input expression:

=IF([ETA or ESD]@row > [Need by Date]@row, "Red", IF([ETA or ESD]@row < [Need by Date]@row, "Green", IF([ETA or ESD]@row = [Need by Date]@row, "Yellow", "Gray")))

The intent is to change the color of the symbol based on a comparison of two date fields. The formula is not populating though.

Any ideas?

Thanks,

Find more posts tagged with

Accepted answers

All comments

Timothy Morgan

Hi Adrian,

Your logic looks sound.

I just reproduced your setup, and pasted in your formula. It worked for me.

What is the outcome of your current arrangement? Are you getting any type of error?

Tim

www.timothymorgan.me

adrian.rodriguez

Hi Tim,

Thanks for taking the time to respond. After reading your response I ran the Shuttle again today, and it seems to be working. There was no error before, it just was not populating the formula.

Frankly I don't know what changed, but it's working now.

Thanks again,

Adrian

Tim Morgan

Glad to hear!

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