-
Must start / must end date restrictions
Dear community I'm a Project Manager in the field of business administration. I'm a former MsProject user. I'm very happy using Smart Sheet. It's great and I would recommend to use it. However as Project Manager for projects within the administration environment I do have a desperate need Smart Sheet does not cover. It…
-
Unhide row
I need to retrieve a row in a master smartsheet. I can see that row in a report output, but cannot see it in the source sheet. In the master sheet row number jumps from 266 to 268 and it's 267 that I need. On the other hand, you can't hide, and therefore unhide rows as such, the only thing I can think of is that I may have…
-
Need some helps on Workflow
Would like to include multi stages approval in my workflow. How can I tie up the approval process with the amount of purchase? For example: is less than $500 only one approval, if between 501 and 2,000 then I need two approvals. How do I set it up in the workflow? The amount of purchase is a single column in my sheet.…
-
Global Updates - Add new column doesn't display the projects
I created new Columns inside a template and wanted to push these out to live projects using Global Update. When I select "Apply Test" then none of the project [Templates] appear 1. I have already done this once before and the projects did appear at that stage. 2. I have also tried another type of Global Update Update…
-
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.