-
Year-to-year best practices when it comes to metrics based on dates?
Greetings- I need some advice in regards to best practices when it comes to tracking multiple years and what to do when one year ends. For example, my SS below tracks submissions via the form by month and year using the formula below for January. =COUNTIFS({Community Engagement Request Range 1}, "1", {Community Engagement…
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
Collect Hours Spent or Planned Hours for Projects using the "Business" plan only
Is it possible in the Smartsheet Business plan to utilize a form to input daily hours by a team member that would add up all hours spent against a project? I was thinking of creating a "Time Tracking Sheet" to be populated with new projects using the "copy project" automation workflow from a Master Tracking Sheet. Have the…
-
Month to Month Trend Over Time to Show Months without Trend
I have an escalation sheet and we're trying to get a report to show how many escalations over time. I was able to bucket them to show by month, but want it to show months that = 0 so it can show a true trend over the year. As you can see in my current report months with no escalations do now show up. (i.e. May, June) Is…
-
Tracking Time
Hopefully this post will help someone looking for a solution for dealing with time in Smartsheet outside of Resource Management. (Bolded the summary for quick access) I've recently run into an issue with a project. We are maintaining a lot of our data in Smartsheet, but a recent project got brought up about wanting to…
-
Issues with TODAY() and daily reporting
Hi there. In part of my duties, I run a report that shows activities entered on a form from yesterday. We do achieve "yesterday" by using the following formula: =IF(DATEONLY(Created@row) = DATEONLY(TODAY()) - 1, "Yesterday", "Not Yesterday") In using this formula we have noticed some alarming discrepancies. Reports with…
-
Tracking the Specific Time of a Cell in One Status
Hi all. I am trying to simply and easily track the time in days a cell is in red status (General Health column in picture below) until it changes. Nonetheless, although we can easily keep track of row changes with helper columns, I really cannot figure out how to do so specifically for one cell. Any recommendation on how…
-
Sum Time Difference in Quarters between 2 Columns
Is there a way to sum the time difference between two columns There is two columns "Start Time" and "End Time". If Start Time = 1800 and End Time = 0600, which falls on the next day. I would need it to calculate 12 hours If Start Time = 1845 and End Time = 0600, which falls on the next day. I would need it to calculate…
-
Smartsheet bug? Time / Rounding formula error
Hi, I'm using the following formula to calculate the difference between 2 times: =IFERROR((VALUE(LEFT([End Time]@row, FIND(":", [End Time]@row) - 1)) + VALUE(RIGHT([End Time]@row, 2)) / 60) - (VALUE(LEFT([Start Time]@row, FIND(":", [Start Time]@row) - 1)) + VALUE(RIGHT([Start Time]@row, 2)) / 60), " ") And then using the…
-
Dashboard Element, Count By Created, Grouped by Time (Hour)
I'm able to quickly accomplish this in Excel, but have no idea how to achieve the same in Smartsheet. We have a call log where a new Created row is automatically generated on submission. I'd like to create a graph that totals all calls by time, specifically the hour of the day. In Excel I create a pivot on the Created…
