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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!