Simple formula =TODAY() - [Report date]@row working well except for one cell

Ruth.Quigley

Ruth.Quigley ✭✭

01/21/24 in Smartsheet Basics

screenshot SS 2.png

screenshot SS.png

Can anyone advise why this is so please?

0 ·

Best Answer

Ric T ✭✭✭✭✭✭

01/21/24 Answer ✓

It may be because your report date is "30/10/223" instead of "30/10/23" :)

0 · Share on Facebook Share on Twitter

Answers

Ric T ✭✭✭✭✭✭

01/21/24 Answer ✓

It may be because your report date is "30/10/223" instead of "30/10/23" :)

0 · Share on Facebook Share on Twitter
Ruth.Quigley ✭✭

01/21/24

Embarrassing but yes - all fixed thanks :)

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
Is there a way to merge user groups?
Two teams at my company have recently merged into one, and I was wondering if there's an easy way to merge their Smartsheet user groups into one group. I don't see a "merge" option available in the Group Management portal.
Attendance reports
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition? Please…

Help shape the future of Smartsheet.
Share your ideas and feature requests.