-
How to use project status report and templates
Hi, I'm still new to ss and how to use free downloads! I'm stuck on how to use the Weekly Project Status Report Template like its shown in the image marked "report layout". I downloaded the template to which I have to complete the data (ref. image- "template layout". The issue is that I'm missing a key step to convert the…
-
Formula to count rows in a report
On a sheet, is there a way to write a formula to count how many rows are on a report. We have many reports and would like to know how may rows are in each report on a single sheet.
-
Create a report from multiple sheet but with row as Columns
hi Friends, I am trying to make my Smartsheet work better for my user. the problem that I am facing id the following My Workspace is build in the following way. Each of our project have a specific folder name let say Project1 , Project 2, Project 3 In each of that folder we have many many files, one of them there is a…
-
Icon sets, driven by formula column, are not showing correctly in reports.
I have set up two icon set columns in my sheet. For both columns, I'm using a (different) formula to drive which icon is displayed. Both columns work fine and display correctly in the sheet. However, when pulling these columns into a report, one of them is not displaying the icons correctly. The column labeled "health"…
-
Multi-Sheet Cap for Reports/Pivots/Dashboards
Good morning, I need to report on data spread over 50+ sheets that are updated independently. The plan had been to place all these sheets in a single workspace and run a Dashboard or a Pivot referencing them all, but I cannot find whether there is a limit on the number of sheets a single Dashboard or Pivot can reference.…
-
Is there a way to save and recall sheet layout (i.e. column visibility, order, width, etc.)
I provide updates to different groups in PDF and Excel format. Not all columns are visible to all groups, and they aren't always in the same order for all groups. I'm wasting more time than I would like unhiding and re-hiding specific columns, dragging the columns into the right order, and then setting the column widths,…
-
How can I automatically get all files in a folder for a report, even when new files get added?
I know that I can click on the folder that contains a set of sheets and it will pull in all those sheets, but when I add new sheets to the folder I still have to explicitly select them the next time I open the report for them to show up. Is there a way to trigger the inclusion automatically or am I doing it wrong?
-
Using "Current User" as a filter in reports - User states report not updating
Using "Current User" as a filter in reports I have a Current User report on our project dashboard to allow project team to filter their tasks due to be completed across multiple projects. When the user updates a sheet to complete, it does not update the report. The report only pulls status not equal to complete and…
-
Create a Report that Includes Newly Added Sheets Automatically?
Is there a way to have a report built off of ALL sheets in a workspace - so that when a new sheet is added, it will be included as well without manual manipulation? Here is the use case: We have a project checklist that includes a expiration deadline date in each summary. All new projects added will have anew folder…
-
Schedule Variance
How can I copy columns from one template and add them to a different template? I want to add the date variance column from the Project Gantt and budget template and add them to the Project plan template. I just want a way to baseline and track schedule variance.
