I am trying to report via a summary sheet the date that the a sheet was updated. I am wanting to report when any row on the sheet was updated not just a specific line.
I'm hoping that its something really simple that I've missed.
To get the most recent update to a sheet, add the Modified (Date) auto column to the Sheet in question
In your sheet summary field use formula =DATEONLY(MAX(Modified:Modified))
This will look at the whole column and pull the most recent date out and report it in the Sheet Summary
See here: https://app.smartsheet.com/b/publish?EQBCT=b6e4ba10eb864281b971da1be6dfc116
If this helped, help me & the SSC by accepting and reacting w/ 💡insightful, ⬆️ Vote Up, and/or ❤️Awesome!
PS - If you have a follow up response tag me @SoS | Dan Palenchar so I get notified of your reply!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I created a timesheet and a form to go along with it. When someone uses the form and flags that someone has called off, I want the flag to return zeros in the ST Hrs, OT Hrs, and DT Hrs cells. Using AI to generate the formula below, it returns a Circular Reference error when the formula is placed in the ST Hrs cell.
I have created a form that is for use with two separate groups, fields become available dependent on how respondents answer questions. I have a VLOOKUP formula set to pull in the address information from another sheet. Because this is used between two separate groups, there are two name fields. I am trying to compare both…
Not sure if this is possible. Column can vary from 2 to X cells A couple of scenarios: A column two cells with 12 and 14. Total is 26. In the resultant cell 16 is inserted. (any sum of 17 or greater the number 16 is inserted) A column has a number of cells that total 14. Seeing that the number is less than 16 the actual…
©2024. All Rights Reserved Smartsheet Inc.