-
Report planned work on a weekly basis
Is there a way to know the estimated % of work to be done every week? I didn't find a report about this, but this will be very helpful to track the overall execution of a project. Example: week 1=5%; week 2=18%; week 3=24%; week 4=32%; etc...
-
Saving Errors
Hello, I am recently unable to save changes made in Smartsheet. I have tried everything that I can think of to get around this glitch, but nothing is working. Has anyone else run into this problem before? See screen shot attached. Thanks!
-
Date Format
Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled to another application (Domo), but it needs the correct format when being transferred over. How…
-
Sort Column based on a Time
Is there a way to sort a column that contains a Time. There doesn't seem to be a way to format the field as Time format, only Date, Text/Number. And number doesn't work on 12 hour entries. Any ideas? Thank you
-
My first automatic RYG/RAG schedule status formulas
Hi everyone. This is my first new discussion. I wanted to share some automation I put into my schedule that made it much more friendly. First, I have a few key columns: * Status (Drop-down, manual entry, "Not Started" or "In Progress" or "Completed") * % (Manual, progress on completing a task) * RAG (Automatic, shows Red,…
-
Is there a way to edit recipients when scheduling sending a reoccurring report?
I have some reports set up to be sent as attachment to people on a reoccurring basis. The distribution list occasionally changes. When this happens, it appears that I have to delete the schedule and start from scratch, however I am able to edit the schedule of when it is sent and frequency. This can be a pain when there is…
-
Calculate each task's percentage completed by days gone by
Hi everyone, I have been trying to work out how to do this using lots of threads here but don't seem to be getting anywhere. I want to automate the percentage complete for each task, based on the dates. So if a task has gone past its end date, it would be 100% complete. Can anyone help? Many thanks, Katie
-
Google Team Drives
Is there any plan in Smartsheet to improve adding attachment as a link from new sharing type in TEAM DRIVE from G Suite?
-
Sights and day prior information
Hi Team, Question - we have a sheet which is populated via a web form. We want to create a Sight that only shows the day prior's row. So, if today is 10/5/17, we want the sight to show the detail from 9/5/17 only. Can't figure out a way to do this. screen shot attached for explanation. Thanks, Kylie
-
Enable and Set Up Auto Logout
Is it possible to set Smartsheet up to automatically log off users due to a period of inactivity?