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

Copy rows
Hi, I am trying to use an automation workflow where I copy a row from one sheet onto a row from another sheet when certain criteria are met. When I go to type in the name of the sheet I am trying to transfer the rows to, it does not show up in my options. However, when I try the same thing on that transfer sheet, the…
Pulling a List of Names to a Preferred Contact List
I need to maintain hundreds of log sheets. On the sheet, we use a Contact List column with a preferred contact list. On the form, we use radio buttons to easily select from the list. While this system works well, I've come across a limitation: when we have personnel changes, I need to change the preferred contact list on…
Top 10 for the month.
I have a sheet with a count formula and rank formula. I also have a report from that sheet that give me the top 10 I also have a dashboard metric from the report that visualizes the top 10 in a graph. I want to show only the current month in the graph, how do I do this? Do I need to create 12 different reports, one for…

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