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:
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
No, timestamping is not a function of Smartsheets at this point. It would be great to have this functionality so I suggest submitting a Product Enhancement Request.
This could be done with Zapier, if your Dependencies are not enabled.
See this post for some ideas:
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
Craig
Submitted. Thanks!
I've also run into this post here discussing how it could be done via formula. The main issue with that methodology is that any new entries would have to have that formula manually put in each time.
You're welcome.
why cant this be done with a ghant chart?
Hi bbuck, the issue with that formula that I originally posted --- is that the formula for today() will always update the date to the current day whenever the sheet is opened. The Today() formula always displays the current date. So that post is not a working solution.
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,…
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…
I have a sheet with 5000 rows and 30 columns. with 4 columns of them are formular columns. How can i reach this limit for 25000000 formular cells reference? How can i enlarge this limit? I need those formular to link some data from another sheet as there is also Max cells limit for one sheet. How can I join those data…
