-
How do I count how many projects are "In Progress" or "Completed" ?
HI There, I feel this should be easy to figure out but i cant seem to! PLEASE HELP?! I have a column called "STATUS" , I have a drop down menu with the following under Status STAUS On Hold In Progress Cancelled Completed How do I show / count how many projects are "on Hold" or "Completed" or "Cancelled" Ideally this will…
-
Need help with creating report(s) with data from a Survey
Hello, I am still fairly new to Smartsheet and need some help turning around data from a survey I sent out. I have 600+ responses that I used the Request an Update function in Smartsheet to obtain, that I now need to summarize and I have no idea how to start the summary process. The survey is regarding Security Services at…
-
Sum Formula with other data is cells
Hello - Hopefully this is a simple question. I have a column that I am trying to sum the data in but the cells quantities and data inside each cell. Is it possible to sum the total quantity for the column? I am trying to avoid using a helper column to move the number out and sum off that if possible. The quantity's can…
-
Alert Someone Automation - Reference Contact In Summary Field
When configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the body of the sheet.
-
Correcting chart spacing
I am creating a chart on a dash board using a sheet summary report pulling data from 2 sheets. I am having difficulty arranging the columns as desired no matter how I adjust the widget tools or the columns in the report Specifically, One column that is pulling data from sheet "A" is on the left and the other 3 columns…
-
Sheet summary formula to SUM a column where cells are formulas
In my sheet summary, I am trying to sum/total a column where the cell values are populated as a result of a formula. I can't seem to get a value. The formula for the cells I am trying to sum is this: =IF([Item Type]15 = "Stand Alone", "150", IF([Item Type]15 = "Unfolding", "450")) It is referring to one other column. I…
-
SUMIFS - #Invalid Operation - Why?
Hello community, there is a formula problem which troubles me slightly. These formulas work perfectly fine =COUNTIFS({6M_category}, HAS(@cell, [Primary Column]@row), {Time of occurence}, >=[Start Date]#, {Time of occurence}, <[End date]#) & =SUMIF({Impact_to_production_hrs}, >0) BUT this one, does not and returns "#invalid…
-
How have folks summarized statistics from multiple sheets to feed a chart widget?
Our marketing folks use a new sheet for every campaign. During the span of a few months, there could be several dozen such sheets active. They are all built from a template and reside in the same folder . Within each sheet there are several summary fields that can indicate number of tasks, number of unstarted tasks, number…
-
How to add card and calendar view on Dashboard
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza
-
Sheet Summary CountIfs with Multi-contact fields
Hi, Is it possible to use a countIfs in a Sheet Summary referencing multi-contact fields? I would like to count the number of instance "Employee X" is in the responsible field column. However, i can't seem to get it to work. I tried using both Has and Contains function in conjuction with countIfs and no luck! Has Formula…
