Is it possible to find the most recent date, from an available date range ?
Thank you very much
I have used the MAX formula to find the most recent date in the past.
The formula would be =MAX([most recent date])
Thank you very much for your help Cheryl.
It's so simple, really !
No problem Christophe, glad it worked.😊
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have two Smartsheet's. The First Smartsheet contains all the original data. The Second Smartsheet will contain unique values from one of the columns (the column with a 1 in the IDUn... column). In the Second Smartsheet, I need formulas in the individual column row fields to look up and match the value in the IDUn...…
Hi, I am trying to calculate duration and I have tried every formula I can google leaving me with unparseable or incorrect argument set... the fields I am trying to use in my metric sheet are "Actual Start Date" and then TODAYS date. I currently have several variations of this =IF(TODAY() - [Actual Start Date]@row)) or…
I'm working on a project that distributes free car seats and we collect data from family members for up to 4 children per family depending on their car seat needs. One entry may include 1, 2, 3, and/or 4 children and we ask for specific demographic data per child. Again, all collected in entry so across multiple columns…
©2024. All Rights Reserved Smartsheet Inc.