-
How do I create a pie chart from the data on my sheet? Assuming I need a formula?
I have a column with rows of dollar amounts called Grant Amount and a column with a drop down menu of three options called Scope of Work. My goal is to create a pie chart on my dashboard showing what percentage of the total amount of dollars from the Grant Amount column is going toward the options chosen in the Scope of…
-
Dashboard Update Automatically Daily
Hello, I'm having issues with a dashboard I have set up, not updating information from a sheet until that sheet is opened/refreshed. I currently have a sheet with rows of names and corresponding dates; basically, shift schedules by day. I then pull whatever names correspond to today's date into a sheet summary and have a…
-
Symbols in Sheet Summary Pane
Hello All, Thank you in advance for your help. I have a Red, Yellow, and Green symbols column in my grid view. In the sheet summary pane I want to have a summary column that provides the minimum value of the symbols column. When I use this formula in the sheet summary, =MIN([Project Health]:[Project Health]) I just get the…
-
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:…
-
ISBLANK AND formula issue
Hi Community: If a task has gone unassigned for >=5 days after initial entry has occurred AND the task has not been assigned to someone, I need to flag the concern and workflow route to a specific individual. Column A: Intention for IF this column is BLANK (fyi Properties of this column is dropdown list) AND Column B has…
-
"#invalid column value" Error in Sheet Summary
Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong with my formular?: =INDEX(Finish:Finish, MATCH([Field 16]#, [Task Name]:[Task Name], 0)) Many thanks in advance for any help…
-
SUMIFS with multiple criteria per quarter
Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_local - want to only find those designated "national" Start_date - only need between 1/1/2025 - 3/31/2025 Reach - need the…
-
Sheet Summary Formula to Rollup Parent Statuses
Hi, I have a working formula in my sheet that works beautifully to rollup/count the status within the sheet: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress",…
-
Can analyze data be used in sheet summary or dashboard
It would be great if the analyze data tool could be copied to the sheet summary or dashboard to continue to be updated as new data comes into the sheet. Is this possible?
-
Need help with a couple Formulas for On hold and Certain Counts
First formula - In a sheet, in sheet summary I need a formula to count the instances certain Project Channels show up. There are three that will need to be counted. For now let's just call them Channel 1, Channel 2 and Channel 3. They are a dropdown column. Second formula - same thing-same sheet and sheet summary formula.…