We need to track all training by hours and minutes, not days, and I can't find a solution to be able to calculate this with a formula. Anyone able to help? Thanks!
Hello, for a few days I have been trying to automate time, not by days (because in smartsheet automations time is automated in days when recording a date) but in hours, so that through automation or a…
I have a colleague looking to demonstrate the power of Smartsheet for project management and task management. She is trying to create an example of the task management and predecessor functionality us…
Hi all, This should be straightforward but I am stumped! How do I get the earliest (or latest) value including time from a Modified Date system column? e.g. I can get the date if I define my output co…
I would like to track hours each week. We have an automated update that goes out weekly and will ask how many hours were spent on each project/task. I would like to add these to a running total of hou…
I'm creating a higher level report that summarizes data from a Smartsheet. This Smartsheet contains the number of hours staff are assigned to in one column. I have an allotted number of total hours th…
We submit time projections by hour instead of by %ages. I am aware that RM sheet daily hours are converted to %ages to sync between RM and SS. However, hours are needed for calculations and dashboards…
Currently we can only use filter expressions and automation that are based on current day or previous day etc. Why can't we filter by past hours or other similar terms? It would add so much functional…
Hi, I am trying to figure out how to calculate the CTC hours month wise used by the task and the role seperate. Is there any way to find it using formulas or widgets? Appreciate your help