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 column groupings showing text under the grouping name
I am attempting to create a report that groups ticket IDs by the report name. The grouping is based on the column named "Report Name Internal (Final)" and the undesired text being displayed is from the primary column. The grouping name displays text from the primary column below the report name. What's odd is the undesired…
Can't Get Conditional Formatting to Work
We're trying to identify new hires who are not producing to goal (see image (18) below to see the target ranges based on time in role). I have entered in what seems like conditional formatting that should work for 0-3 month new hires at their Month 0 mark (trying to turn red anyone below $30,000.00) but it's not working.…
Inactive Form and customize the message
Hello, We use a form to for intake of projects. During a time period, we would like to deactivate the form with a message of 'if this is an urgent request please contact leadership'. I understand how to deactivate the form, but wondering how I could display such message when customers try to access/open the form? This is…

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