-
Reference is changing data type from DATE to TEXT
I having a an issue here and wondering if someone can help. In the screenshot, shown, ROW 2 is giving an error when I attempt to calculate the variance between Fiscal QTR End Date and Opening date ROW 3 is not giving an error. Here are the differences in the rows. Row 2 - Both Date fields with referenced from other date…
-
Limiting the dates that print in Smartsheet
I want to create a Smartsheet project that has a Start Date of July 1, 2019 and End Date of September 1, 2020. I want to set the timeline to Years/months. When I view or print it, I only want to see the months associated with 2019 and 2020 and I don't want to see any months in 2021. How do I do this? I can't hide the…
-
Project To show duration not dates
My Project has not got a start date so I want an option for weeks and months and the gant chart to show Years Months and Weeks. I am relatively new to smartsheet so any `dummy help' would be appreciated.
-
Project Management: Weekly capture of actuals against planned hours
Many thanks in advance! We have a team of project associates that are asisgned to a number of tasks on a project in a smartsheet. I want to be able to send a timesheet to each resource at the end of every week. On the timesheet I would like to display the task for the week and ask for actual hours to be entered. These…
-
Allocated Time % versus Duration
Can anyone tell me the correlation between Allocated Time % versus task duration? If I estimate that a task will take 2 days (16 working hours) to complete but then assign someone to it that only can work on it 50% of the time, why will the system automatically create a start and end dates that are consecutive days? Since…
-
Limiting what customers can and cannot see for projects
We use smartsheets to run our customer projects. The approach we have used to date is to create a workspace for each customer, with the necessary sheets - all from a template. This works really well, as the customers need to review and contribute to several of the sheets that we use, and the workspace sharing feature lets…
-
Auto/number - date on particular cell, not whole row
I'm trying to find a way how to populate a datestamp in a cell based on the last change from an another cell in a particular column fe: Row 1 - column A: dropdown (Start, pending, stop) Row 1 - Column B: I want the date when Status changed on column A Auto/number - date: works, but it looks at every cell on that row, i…
-
Add Vacation to Individual Project for Individual Employee
I want to denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in smartsheet?
-
Working with an update request workflow
Hi, I have setup a workflow around an "Update Request" but the one field that I would like them to be able to update does not allow it. I have checked that the field is not locked as well. I have attached a snap shot of both the workflow and how the form comes through. What am I doing wrong?
-
Smartsheet for Inventory using QR codes
Hello everyone, I'm a teacher who has to manage a "MakerSpace" - a design studio with lots of electronic equipment. It would be ideal if I could place a QR code sticker on an object, take a snapshot of it with the camera on an ipad, and arrive at the inventory Smartsheet that I've created where this object's original…