Changing symbol if Date1 (Field1) is less than 40 days than Date 2 (field 2)
Hello,
Can someone help?
Answers
-
Hi Roberto,
Try something like this. I've used a Flag symbol in my example.
=IF(OR([Date1]@row = ""; [Date2]@row = ""); ""; IF([Date1]@row - [Date2]@row < 40; 1))
The same version but with the below changes for convenience.
=IF(OR([Date1]@row = "", [Date2]@row = ""), "", IF([Date1]@row - [Date2]@row < 40, 1))
Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.
Did that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thanks Andree. I will give it a try.
-
Andree,
I am using a rag status and it worked. Thank you so much. =IF(OR([Target Launch Date]1 = "", [Target Delivery Date]1 = ""), "", IF([Target Launch Date]1 - [Target Delivery Date]1 < 40, "Yellow")). Now I am trying to capture the other two status.
Green if Target Launch Date is more than 40 days
Red if Delivery Date passed or greater than Target Launch Date.
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
It does not seems to be working when I try to add the other RAG status.
-
What formula are you using?
Can you maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andree,
Not sure how I can add the two other RAG Status in this formula.
=IF(OR([Target Launch Date]1 = "", [Target Delivery Date]1 = ""), "", IF([Target Launch Date]1 - [Target Delivery Date]1 < 40, "Yellow"))
This formula is working; however, when I am attending to add these other status logic, the formula stop working.
Green if Target Launch Date is more than 40 days
Red if Delivery Date passed or greater than Target Launch Date.
Thank you,
Roberto
-
Can you paste the formula you're using?
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!