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,
A
Answers
-
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
-
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
-
Glad to hear!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.9K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 457 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives