Automation showing false result on the formula

Cemil Binlik

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

heyjay

How is the remaining days being entered? What is your set up to complete this column?

Cemil Binlik

=IF([End Date]@row - TODAY() > 0, [End Date]@row - TODAY(), "0")

Cemil Binlik

Like I mentioned, when you go to the sheet itself, it shows correct, but generated report comes in false

Cemil Binlik

Any advise on this team?

Andrée Starå

Hi @Cemil Binlik

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: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

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!

Cemil Binlik

I'm giving it a try @Andrée Starå 🤞

Andrée Starå

@Cemil Binlik

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!

Cemil Binlik

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

Andrée Starå

@Cemil Binlik

Happy to help!

Can you elaborate?

Cemil Binlik

@Andrée Starå

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: