Automation not working as intended
Hi all,
I have a sheet in which I'm tracking installation dates of equipment (outside vendor) and have automation to fire off to ensure the necessary pieces all fall in line (in house), within a timely manner.
However, something must have changed in the last couple of weeks, because it's fallen on its face and I'm having to manage the automation, thereby making the automation useless.
The columns "Has Install Date" and "Ship Hardware Check" are column formulas, and the key aspects here.
Has Install Date
=IF(ISBLANK([Chair Install Date Actual]@row), 0, 1)
Ship Hardware Check
=IF(AND([Has Install Date]@row = 1, [Chair Install Date Actual]@row < TODAY(+7), [Chair Install Date Actual]@row > TODAY(-14)), 1, 0)
Then, I have a workflow assigned to flip the check box on "OK to ship hardware". This never happens when I am NOT looking at the sheet.
I have to delete the value from "Chair Install Date Actual", save, reenter the value, save, THEN does the workflow fire to flip "OK to ship hardware".
To summarize, the above worked, some time passed, and now it doesn't. How can I fix it so as to be largely hands off again?
Best Answers
-
Hi, it sounds like you need the TODAY() update workaround, since TODAY() only updates when the sheet is opened or accessed. I suspect this is the issue.
This forum has it explained, in short use the record a date automation to update a helper date column each day.
-
I hope you're well and safe!
Please have a look at my post below with a method I developed to update the sheet(s) daily.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
Answers
-
Hi, it sounds like you need the TODAY() update workaround, since TODAY() only updates when the sheet is opened or accessed. I suspect this is the issue.
This forum has it explained, in short use the record a date automation to update a helper date column each day.
-
I hope you're well and safe!
Please have a look at my post below with a method I developed to update the sheet(s) daily.
More info:
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. 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.
-
Oh, and here I thought I was going crazy. LOL. Thank you!
Funnily enough, I was thinking of switching to something like this instead of using formulas in the cells. Thank you!
-
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
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!