Hello, I manage a RAID log for my team. I want to calculate SLA for each issue. I don't want to calculate if the case is checked in IT column and if it's status is "Cancelled", here is my current form…
Hello All, I am working on a Smartsheet that will allow us to calculate time worked over the course of a day for a group of union employees. I've built out some of the functionality but am running int…
First some background, this is not a consistent outcome, and there is more than a single calculation involved. The Hypercare Ticketing system calculates SLA times and was a bear to build as it is base…
I want to open the discussion in this industry forum because I'm certain this would be a group of folks that regularly encounter this short coming. The inability to put "edays" in the predecessors col…
So, not going to lie, I had to resort to chatgpt for this one after spending 2 weeks, banging my head on this (Got in over my head skill-wise with this one). I've already resolved a few issues I ident…
We would like to request the ability to add multiple conditions to a Conditional Formatting rule. For example: If Step="Backlog" and Flag=Yes, mark row orange.
Hi, I need suggestions for how to track training hours for all employees. Each employee has a separate training sheet - it's broken out by training section with training items underneath. One of the c…
Hi There, I have a Smartsheet and Form that we use to calculate how long a person was checked into a function to account for down time. Since Smartsheet is not very good with calculating time it took …
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…