-
Help with Charts
Hello Community. I am very new to smartsheet. I have created a dashboard and want to add charts from a sheet. The metrics i want to provide are not numeric-based. How can I create the charts without numbers being associated? Thank you!
-
Data Mesh Error
Hi, I am using Data Mesh for the first time. I am trying to populate my target sheet with a report. There is a sheet that feeds the report. New rows may be added and existing rows will be edited frequently. So, I believe choosing "Copy and Add Data" is the correct choice for Data Mapping Format. I have 2 rows in the target…
-
Workflow Toubleshooting
I'm testing my workflows that have 2-3 approvers each, and the feedback I am receiving is that the approvers are all receiving 10-20 email notifications for the same request. Does anyone know how this might be happening?
-
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…
