Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
Does anyone know if there is a way to produce a report or a list of rows whereby Column A has changed in the last n number of days? I'm trying to produce an exec level weekly report of key projects whose end dates that have changed in the last week.
You would need to include a date type column where users can enter the date that they changed the data in Column A. If Column A is the only column that would be changing once a row is put into place, you could use a system generated Modified (date) type column.
Unfortunately though, if there are other columns in the row changing, the changes would have to be manually date stamped as there is no feature (yet) that allows for an automatic date and/or time stamp of a specific action.
Thank you, Paul. We are playing around with using the sys gen mod date field but as you pointed out, many other columns on the row can also be changed.
You may be able to use a 3rd party app such as Zapier or possibly the Smartsheet API to pull the date/time stamp for a specific action within a set column, but otherwise since multiple cells within the row are changing, you would need to have users manually enter the date/time of the change.
I am not very familiar with the API (at all). I do know though that Zapier links to Smartsheet very easily. I am not sure of exactly the setup you would need within Zapier to accomplish this, but it is generally pretty user friendly.
Hi Mary,
The third-party service, Zapier is an excellent option for this scenario. Is that an option for you?
Hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
Hello, I have a workflow where, when a team member checks a checkbox, Smartsheet automatically sends an email to themselves containing merge fields that are used as a customer email draft. The challenge is that this activity typically happens on a deadline day, and a team member may need to generate 30 or more of these…
Hi all, reaching out to see if of you have ideas; I'm hoping this makes sense: I'm having some trouble getting my formulas to pull data in correctly. I currently have a sheet (primary data) where I have data in rows where each row is a single project, with columns identifying persons, $ values, unique project identifier,…
