I would like to include two columns with those dates
Have you taken a look at the System Columns in Smartsheet? You can add a "Created" Date column and a "Modified" Date column to your sheet to track exactly those two items: when a row was entered/created, and when the rows was last updated.
See: Use a System Column to Automatically Add Information to a Row
Thank you @Genevieve P.
@Genevieve P. is there a way to populate a column with the date a specific cell was last edited?
Use case: We have a % completed column; I want to know when this was last updated. If someone makes a change to another column, then I wouldn't want that to effect the "last updated column". Is this an enhancement request?
If you don't need the time, you could use a Record a Date workflow - this will record the date based on a specific trigger (e.g. that one column changes).
Here's more information!
This is great! Thanks @Genevieve P. !
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.