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.
I've created a dashboard with multiple graphs using data from the same report. I have added the report to the dashboard as well and set up the filter for use in the dashboard. Is this filter transferable to the graphs as well, given i can filter the report in the dashboard?
Dear Community, Can you please advise? I have a sheet where among other columns I have a column listing contacts "Champions" (multiple per cell) the other columns are for example: Countries (a list of 72) The list of Projects (approx 15) - I can add to that sheet, or I can create in a Helper Sheet. I haven't done that yet…
Looking for assistance again, I want to bring in the % complete from the Production sheet to the Schedule sheet, but once the % complete is 100 the data is moved to another sheet, so I would like to reference to check 1 sheet for percent complete and if it is not there check the second sheet. Schedule sheet: Pick Up Date…
