-
Will proper time formatting ever be implemented?
I am creating a form for a log keeping sheet, and want to include a time input, but would love to avoid people having to type it manually. Don't wanna see different entries of '02:00, 2:00p, 02:00PM, 2pm, 14:00, 14:00:00, etc' I see posts from 2015 with this same issue, and most responses are "smartsheet doesn't have this…
-
Need a option to copy only changes for last 7 days
There is a good option to review changes in last say x hours and day , I would like to know how to copy all rows where last changes happened for that filter to only copy and paste to someone asking for delta work for last say 7 days ?
-
Time Tracking - Hours and Minutes
I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-around I made, not the most elegant, I admit.. If Smartsheet could ignore preceding zeros, it…
-
Hierrarchy in web forms
I have data broken out by region (AMER, EMEA, & APAC), and there is budget information contained in each row. The region is a parent and the corresponding rows are children. This allows me to get a regional budget summary. Is there a way to maintain this hierarchy (parent/child relationship) when rows are created using web…
-
nesting properly?
Hi all and good afternoon, im working on a sheet that seems to be giving me an issue and I am aware its my lack of knowledge. Hopefully someone from the forums can give me some insight as to how to achieve my desired result. I have a cells contents with: =-SUMIFS({Transactions Range 1}, {Transactions Range 4}, ="Issue",…
-
Intranet in Smartsheet - Anyone Successful in Transitioning Policies and Procedures
I am attempting to transition our current Intranet over to Smartsheet and the biggest hurdle I currently have is around Policies and Procedures. We are a ISO certified company so document control is a important issue for us. Our current platform allows for linking within one procedure to possible several other procedures,…
-
Control Center Projects - Multiple Selection for Updating Reporting
**Enhancement Request** TLDR: I created a new blueprint summary, and need to add project information to it. Right now, I'm grinding through each project to update and add them to the new summary. Need a better way. I'd like to update reporting on a lot of projects, but right now I have to go into each one in the Control…
-
Format as time
I need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not there?
-
Calendar View - can't drag tasks when Due Date uses WorkDay function?
My SmartSheet has Task Due Dates that are calculated using the WorkDay function. For example, if a recurring monthly task is due on WorkDay 1, that calculated Task Due Date would become Monday, January 3rd, rather than Saturday, January 1st. Approaching the dates in this way makes it easy for us to rollover the Task List…
