Automation showing false result on the formula
I have an automation that is generating false results as you can see below (Remaining Days should be 0). However, when you go the original sheet it is showing correctly (also see below).
I disabled the automation and enabled again but the problem still persists.
Can anybody advise on the solution?
Thanks
Answers
-
How is the remaining days being entered? What is your set up to complete this column?
...
-
=IF([End Date]@row - TODAY() > 0, [End Date]@row - TODAY(), "0")
-
Like I mentioned, when you go to the sheet itself, it shows correct, but generated report comes in false
-
Any advise on this team?
-
I hope you're well and safe!
It's probably because of the TODAY function and that the sheet needs to be opened/activated to update the value.
Please have a look at my post below with a method I developed to update the sheet(s) daily.
More info:
Make sense?
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 support the Community by marking it Insightful/Vote Up, Awesome, 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.
-
I'm giving it a try @Andrée Starå 🤞
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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.
-
Hi Andree,
This seemed to work just for a bit, but started showing false results again, any other idea you can think of for resolution?
Thanks
-
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.
-
Same issue, nothing changed, unless you open up the sheet itself formulas are not showing correct.
Either Status column or remaining days are coming up with false (old) results.
I have the today helper column. and here is the formula, and see below screenshots
Status column fx: =IF([Start Date]@row > [Today Helper]@row, "Not Started", IF(AND([Start Date]@row <= [Today Helper]@row, [End Date]@row > [Today Helper]@row), "Ongoing", "Completed"))
Remaining Days fs: =IF([End Date]@row - [Today Helper]@row > 0, [End Date]@row - [Today Helper]@row, "0")
Automation
Report: Received 2 hours ago, today helper is also not showing correct
Actual Sheet:
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 383 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 451 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!