Best Of
Re: TODAY Formula Constantly Changing Date to Current Date
Hi @AmyBurns_BCD,
Instead of using a formula here, you should setup an automation to record the date when the value changes to "Closed".
The automation should look something like this.
Hope this helps,
Dave
DKazatsky2
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets with an array of formulas and cross-sheet look ups to pull this off. I have it fully functional and error free running right now. It would be amazing if this could become built into the core product somehow.
Derick Gerloff
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets with an array of formulas and cross-sheet look ups to pull this off. I have it fully functional and error free running right now. It would be amazing if this could become built into the core product somehow.
Derick Gerloff
Re: How to use previous cell value (from cell history) in a formula?
https://community.smartsheet.com/discussion/comment/400199#Comment_400199?utm_source=community-search&utm_medium=organic-search&utm_term=cell+history
I have upvoted this idea.
Vishnu Kayarat
Re: Dropdown List Alternative with Automatic List Update and Dynamic List Features
@jmyzk_cloudsmart_jp The first part of your ask (automatic updating of a dropdown list) has just been released and the second part (with dependencies) is planned for release in the near future!
Danielle Wilson
Re: Scatter plot chart - labels & values on both Axis, plotting combined Value vs Effort score intersect
We would like to use a scatterplot for a benefit effort matrix representing the entire project portfolio. I would be great if we could have a tooltip not only indicating the current benefit and effort value but also the project name, allocated from another column.
Bulk deactivation of automations
It would be incredibly useful to enable owners or admins to bulk deactivate automations within sheets. I'm currently having to manually deactivate 144 automations one by one!, the ability to 'select all' would be very useful when doing updates to my sheets.
Gillian C
Bulk deactivation of automations
It would be incredibly useful to enable owners or admins to bulk deactivate automations within sheets. I'm currently having to manually deactivate 144 automations one by one!, the ability to 'select all' would be very useful when doing updates to my sheets.
Gillian C
Remove "Z" at the end of the date/time stamps in Seat Type Report date columns
The 3 Date/Time columns in the Seat Type Report include a "Z" at the end of the value (ex. 2025-11-11 00:07:27.000 Z). This prevents the field from being used as a date without manually removing it or creating a helper formula to remove it. Please remove the Z from the date/time in Last Paid Activity (UTC), Last Login (UTC), and Date Added to Org (UTC).
acurran
Remove "Z" at the end of the date/time stamps in Seat Type Report date columns
The 3 Date/Time columns in the Seat Type Report include a "Z" at the end of the value (ex. 2025-11-11 00:07:27.000 Z). This prevents the field from being used as a date without manually removing it or creating a helper formula to remove it. Please remove the Z from the date/time in Last Paid Activity (UTC), Last Login (UTC), and Date Added to Org (UTC).
acurran