Hi - I created a sheet summary report for 4 project. My Total At Risk column is coming back with the error #UNPARSEABLE even though I used the same formula for that column. Can someone give me some gu…
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 proje…
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?
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…
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 …
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 sugg…
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…
Howdy Smartsheet Community :) During a recent exercise to make Conditional Formatting programmatic, I indexed the color names and hex codes of the 8 x 5 Smartsheet color matrix. Wanted to share the re…
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 th…