-
Sheet Summary Report - Multiple Instances of the Same Fields
I have created a template for our PMO to use and a report based on the sheet summaries each sheet contains. Older projects have had the sheet summary fields added, rather than migrating existing projects to a new sheet based on the template. Something odd is happening - some fields are appearing twice in the column…
-
Sheet Summary Formula to count text cells that are not blank
Hello, I am having a hard time setting up this formula in Sheet Summary =COUNTIF([Core Customer Name]:[Core Customer Name], "ISNOTBLANK" Can someone help?
-
Project Progress/Reporting
I am creating an simple method to help us determine project progress to report back to our customers. The idea is to group tasks into phases and then classify each project as being in a specific phase depending on which tasks have been complete. Once all tasks in a phase have been completed, the sheet will report back that…
-
Using Sheet Summary for Duration and Want to Color Code in Reporting?
We are using sheet summary to show how long each project is in each phase by using =duration1 (or whatever the line number is). My question is - is there a way to color code it a certain color if the phase is still in progress, or on hold, etc, but we have moved to a new phase and it then shows a certain color then in…
-
Since Smartsheet Gov has no sheet summary, where do I put formulas?
I have a sheet I want to move over to the gov version, and when I went to do that I noticed there is no sheet summary. My sheet has hundreds of formulas and it would be useless with out them. Any suggestions on where to put them? Do I make another column called sheet summary?
-
Adding a New Sheet to an Existing Summary Report
Hi there, I have a workspace tracking our grant applications using the Multiple Projects template. Each grant has it's own sheet for tracking the application process, implementation and reporting. The "Report - At Risk" and "Report - In Progress" reports are only pulling data from the original sheet I created. I've tried…
-
Possible to summarize a report based on Current User?
I'm creating a dashboard that summarizes survey data for employees. I have a report set up where they can access their information, and the report is set to filter By Current User, so they only see their own data. The report pulls from a master source sheet, which has a Contact column that maps to each employee. My…
-
Help! Summary Sheet Data Not Linking
I recently changed two column types from Text/ Number to Date columns in my summary sheet and when I created a new project I got the following message… Does anyone know how I can fix this to ensure the data links in to my summary sheet correctly?
-
Can I add logic on summery sheet field ?
I have added a check box in the summery sheet. which I want to be unchecked at certain frequency.
-
Hyperlinks in Sheet Summary not clickable when added to Dashboard as Metric Widget.
Is this intentional?