-
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…
-
Smartsheet Color Matrix Names and Hex Codes + Programmatic Conditional Formatting
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 results with everyone here, in case you have a need to extend these colors through non-Smartsheet collateral: Some details on…
-
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?
-
considering switching from CRM to Smartsheet. What's the best way to ensure a smooth transition
Do we have any standard templates related to CRM in Smartsheet? Appreciate insights and advice from those who have undergone similar transitions or have expertise in utilizing Smartsheet for CRM purposes. Specifically, I'm interested in: Strategies for migrating data from our current CRM system to Smartsheet. Best…
-
Discreetly Alert Users When Summary Field is Present
The Sheet Summary Fields can be incredibly useful in providing sheet instructions or other sharable information to sheet users, however the summary fields are one of the best kept secrets for many users. It would be helpful if there was a means of discreetly alerting the user that Sheet Summary Fields were available. Even…
