-
Can you make reports from reports?
I'm trying to flither information from one report to another and combining certain information. Is there a way to do this without starting with a new report?
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Selecting the Next Task
This is a bit of a weird question but I'm trying to figure out how to make SmartSheet inform me what my next milestone is for a project. Basically I have a series of projects (say 40 or so) that each have their own project schedules. In those schedules, some tasks are marked with a checkbox to indicate they are critical…
-
Live Data Connector
I have a Smartsheet linked to Excel (using the Live Data Connector). When I refresh the data in Excel all data refreshes. Is there any way to limit what appears after refreshing? I only want to show what is new and/or what has been changed in Smartsheet?
-
Sharing reports with free users - content not populating..?
From admin users in our paid team account (based in the office), I am sharing reports with free users (in the field). Up until recently this has worked flawlessly. As of a few days ago, the free users can still see the reports that is being shared with them - but no content is populating. I've tried deleting their access…
-
Report Help
I am trying to build a report that is looking at one "DATE" column and shows everything that is between 45 to 90 days from today. The trouble I am having is getting it to be dynamic rather than changing the date everyday. Is this possible? Any help is appreciated. Thanks, Jason
-
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…
