Why does =TODAY() - Created@row give inconsistent results?

I have an auto number column [Created] that captures the time a row is created. In another column [AGE], I am trying to calculate the age by using the formula =TODAY() - Created@row. For some of the rows created today, this formula gives an AGE of 0 days, but for others it results in -1. What am i doing wrong?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!