Sign in to join the conversation:
Is there a way to create a report that queries a sheet and shows any rows that haven't been modified in the last 30 days?
Hi Stephanie,
Yes, it is! You'd add the Modified Column and is in the last 30 day(s) in the When section.
Did it work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
What about creating a report that shows if a column has NOT been modified in the last 30 days?
When adding the condition of when the date is within the past 30 days, there is a checkbox at the bottom of the criteria window that you can check to exclude rows that meet that specific criteria and show everything else.
I missed adding the NOT.
No worries. I do it to myself all the time.
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere