-
Unknown Workspace In Report. Not Showing all Data
So we have a manager here who builds reports for his employees and shares those reports. However, we ran into a peculiar issue yesterday. One of the employees reports stopped showing all data. So the manager shared the report with me (I am admin and owner of all sheets on the report) When I click the report, absolutely no…
-
Values not appearing in linked Excel table
I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. I have another, very…
-
Percent Complete not adding up
I need some help figuring out how to make my "% Complete" column reflect the actual percentage using my "Hours" column and not "SLA" (days). The sample below is clearly incorrect. It should be more like 64% complete. I'm totally stumped.
-
Master Project Sheet vs Master Project Report
We are looking at implementing either a very large (roughly 160 columns) master project sheet or a master project report. If we go with the master project sheet, teams would work off reports to update their respective data. If we go with the master report, I would aggregate specific data from each team sheet. The end goal…
-
Getting an overview of all changes
Hi, As administrator I like to see all changes that have been made and files that have been added in a given period on all sheets in all workspaces. Is there a way I can do this?
-
Collapsing rows on report
Good day, Is it possible to collapse rows on a report? Y
-
Auto fill with data from another sheet
So I'm not sure if this is possible. I have a sheet that has all of our employees on it. The list has four regional directors as the parent. Under them as the child are 5-10 field managers. What I'd like to have happen is if I made another sheet and set it up so if entered "Tech 1" it would auto fill who their "Field…
-
Sorting reports - line number
Hi, please enable the original line number as an available sorting criterium in reports. Helpful e.g. when sorting by (1) sheet name and (2) original sorting order within the sheet. Thank you
-
Problems with Cell Linking Updates
I have a sheet that lists employee data, that links to a table of assigned managers. Next I have a report for each manager that pulls current employees data, this has been great; however I have begun noticing missing rows. The report does not appear to be 'seeing' the new manager when the managers table is updated. The…
-
Display jobs for the week and who worked on it?
I want to create a sheet that can show the jobs for each week and who worked on it (multiple people can work on it, due to different departments).
