How to Count Time
Hello, I am very new to functions on Smartsheet, and any help will be greatly appreciated. I am trying to create a sheet with times (minutes and seconds) and attempting to implement a function where if a checkbox is checked, it will count the time from the time column. Can you provide guidance on how to achieve this? Thank you!
Answers
-
There should be something for you in this thread:
-
Hey @Robertas
@Paul Newcome has created some fantastic solutions regarding working with Time in Smartsheet using formulas, which he linked above.
Since you mentioned you're new to formulas, I just want to clarify that there is no direct way to measure time in Smartsheet in Minutes and Seconds. You could use a Record a Date workflow to record the date that the checkbox is checked, and the time would be stored in the Cell History, but there isn't an easy way to automatically have a timestamp in a cell and then perform calculations off of that (other than Paul's formulas above).
Here are some Product Idea posts you can vote on to provide your feedback to the Product team:
- Please let Smartsheet work with time
- Date and Timestamp Action in an Automation Workflow
- Enhancement Request: access values stored in cell history
An alternative to the formulas above would be to use a third party application to get the data you're looking for, then import that content into Smartsheet afterwards.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
@Genevieve P. Thanks for the extra info.
@Robertas If you do end up needing to grab a date/timestamp from a specific action, here is a link to a solution I have developed. The basic idea is to use a copy row automation triggered when the action takes place and then an INDEX/MATCH to pull the date/timestamp back to your working sheet.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives