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:
Hi all
I am trying to capture time spent on specific tasks through a form. My idea is that the user can click a start button(could be a checkbox) to start and i can capture the time modified and a complete button to finish(same thing). We can then calculate the duration to be the difference between those tow entries. Is this possible with smartsheet ?
Thanks,
I think this is a duplicate of this post:
https://community.smartsheet.com/discussion/formula-mesasure-running-time
Upon rereading that post and this one, it occurs to me that this Zap
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
could be modified to have the full timestamp instead of just the date. It will be off a little (the Zap does not run immediately), but might be close enough.
Craig
In my Project Plan sheet, there's a link labelled Project Plan. When someone clicks it, I'd like nothing to happen. Ideally, it would still look like a clickable link but wouldn't open anything.
I have an automation copying rows from a source sheet to a destination sheet. The destination has additional columns that do not exist in the source. Those destination columns are set to centered and not bold, but newly copied rows come in bold and/or not centered, while others are fine. Columns are Text/Number Conditional…
We do not currently have the Calendar App. We manage multiple project plans across many workspaces and would like to provide leadership with a consolidated calendar view that displays only tollgate tasks across all projects for a given month, rather than all project tasks. Ideally, leadership should be able to view the…
