Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
Smartsheet, here is my plea: Please add functionality to track time in schedules and resource management. In order for our growing organization to continue to leverage the power of Smartsheet and the connected Resource Management tool we need to be able to track tasks and resourcing down the hour level. This would be a…
I'm desperate for calculating hours help 😩 I've created a report sheet for incidents in our department. These are submitted using a form and the incidents are managed by several people. The idea is that depending on the severity of the incident, we should alert the incident owner so they can update the status and leave…
Hi guys, I need some help to calculate the hours and minutes have elapsed from a system column (which is the ticket creation date) to the present date, not sure if it is possible to use TODAY() formula. Here are some screenshots of what I have so far, but seems like the minutes calculation is not working. The ultimate goal…
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 formula, a time can be recorded when a cell is modified, and at the same time those hours can be operated on, adding or…
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 using a typical American Thanksgiving dinner. The issue is Start and end date are only able to be calculated in days from what…
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 column as type Date and use a simple MIN/MAX but this means the time is ignored. I thought about breaking the time and the…
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 hours. Bonus points if I can have the "Hours logged this week" zero out after it is added to the actual hours column.
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 that staff can draw from. I'm wondering if there's a way that I can add the total number of hours they can use to the…
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 at this time. We would like to see raw daily hours reflected in RM available for reporting in SS. Would it be a huge lift…
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 functionality to Smartsheet in its various functions, such as project for one when assigning task durations by hours or to filter…
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
My company is trying to log "client travel time" (aka not consulting time) for projects as a separate phase for any given client project. That said, travel time wouldn't be logged too often and we have a preference to not have is show up automatically on staff's timesheets. I'd rather allocate the bank of hours to any…
It looks like you're new here. Sign in to post and engage.