-
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
-
Manufacturing Production Report
Hello, I work for a relatively small manufacturing company where our production managers meet every single morning, give their production numbers, headcount, etc to the manufacturing managers for them to enter the data manually in excel every morning. We created a form in Smartsheet for the production managers to enter…
-
How to hide attachments and Comments in Reports within WorkApps
We have some internal sensitive data saved as attachments that we do not want our clients to see. I have hidden the Attachments and Comments Column on the Reports and saved them as View Only within WorkApps. However, the users can still view the attachment even though I have hidden the Attachment column, by right clicking…
-
Report won't SUM column with values
I've attached a screenshot of my report of our budget. The column called Budgeted I originally had named Budgeted 2024. When I renamed it to just Budgeted, I deleted off the Budgeted 2024 column, refreshed, and added the new Budgeted column. I now can't get it to sum.
-
Report Formatting
Hi everyone. Is there a way to format a report I built. I would like to change fonts and background colors?
-
Ignore duplicate rows in a report
Hello, We record certain metrics about our clients anytime they visit our physical location. This usually isn't a problem because they don't come in too often; however, there are a few times a year when they are scheduled to be onsite multiple times a day. This leads to their name showing up repeatedly on the report we use…
-
Is there a way to exceed the 1,000 sheet limit on a report?
We have a report that is made up of a lot of sheets and always growing. Is there a way to increase the sheet limit or would the only option be to delete older sheets in order to add newer sheets to the report?
-
Elapsed Days Counter - How?
Hi everyone, I'm needing to report on elapsed days for a few tasks. Anyone know how to do this? Note - this is different from the 'duration' function that already exists in the Gannt view. That is where I have a start and end date. In this example, I have a start date, but no end date quite yet. Any help is greatly…
-
Report not showing all rows that match the filter parameters
Hello! I have a sheet that has 3424 rows with a specific Due Date. When I look at that filter option in the report, I see that it sees 3424 for that field. However, when I add that parameter, only 2500 rows display. I can't find a row limit to reports that would cause this. Is there a row limit to reports that I'm unaware…