If there is no activity in the sheet in the past "X" days, we should be able to create an automation to alert someone. It is really important for the sheets that are updating automatically so if the automation is broken, the user can be notified,
Sign in to see the current vote count, add your own vote, or leave a comment.
Voting in support. This is already possible if you can add a formula to your sheet, but I still think it would be a nice add to the workflows.
I do something similar using a helper column or static cell in my sheet to collect the most recent modified date. I use the formula below:
=LARGE(Modified:Modified, 1)
Then set a workflow based on that date.
I use it to send update requests if someone hasn't updated a row in a certain number of days. An automation will also update the modified date.
Thanks! LARGE only looks at numbers in the given range. I am getting #INVALID COLUMN VALUE error since the modified column has date and time.
Hmmm.... LARGE should work... I have it pointing to a 'date modified' column with a date+time. It may be where you are placing the formula... if you are using it in a non-date column, I think you need to use the following formula to convert the output to text
=(LARGE(Modified:Modified, 1)) + ""
I am not sure, but the #INVALID COLUMN VALUE may be coming because you are trying to put a date in a text column. Below shows how it's setup in our sheets. I am not running a workflow from this date, so used a summary row at the top in a text field.
Not sure if you can trigger a workflow from a date recorded in a text field... so would need to create a helper date column, or if you have summary rows at the top you could leverage an existing date column you already have. see below.
Then workflow would look something like this...
Hope that helps!
Thanks much! You are correct. I was putting date in the text column. :(
As one of the system admins, it is absurd to me that I cannot view or have access to all of the items created in my organization. We have over 11,000 reports, sheets, and dashboards and I can't see them. I have no visibility to if people are using our plan for their own personal use, or what kind of work is going on unless…
I noticed this the other day and tested Ctrl + M – it does not work. I submit ticket to Smartsheet support – they told me that’s expected behavior because it’s not currently available even though it still shows as keyboard shortcut in the menu🙄 and told me to submit new product idea. Please add this keyboard shortcut to…
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
