-
How to use COUNTIF in a Sheet Summary Report
Hello - I am trying to add several COUNTIF formulas for different lines in my Sheet Summary Report. I would like the formula to reference how many times the status Action, Risk, etc. are in the column. I only get INVALID REF or UNPARSEABLE. I have tried the below among others, thank you! =COUNTIF({Log Entry Type},…
-
How do I calculate the sum of a length of time column in the Sheet Summary
I want to be able to calculate the total length of time of all the video files in a sheet for the Sheet Summary. (to then be able to report across multiple sheets, populate in a dashboard etc). These are not formulas and there is also no start or end time as this is the length of a video, not work time. Also, as these are…
-
IF Formula with Multiple Choice
Hello! I want to build an IF formula into columns when the multiple boxes has selected the right department. IF the Authorizer is marketing and finance, the emails would automatically populate in marketing and finance column. Not sure if this can be done. Would appreciate your help greatly!! Thank you very much.
-
Merged: Use of sheet summary fields (or formulas) in automation
This discussion has been merged.
-
How to list values in a cell based on another cell with distinct names (in a list format too)
Hi, We are trying to present the labor hours workers have dedicated to one same task on different instances. We started by nesting =JOIN(DISTINCT(COLLECT({Worker}, {Task}, "DC6-" + [Task Label]@row), ", "), ", ") We have successfully filtered a list of workers that have dedicated hours to a task. We would then want to…
-
Robust Sheet Summary Feature would be cool!
I would love it if Smartsheet had a more robust sheet summary, rather than creating those using formulas on the grid, or creating a dashboard to pull in those summaries/formulas from numerous grids. The sheet summary on the right menu often doesn't capture all that you would like and give limited flexibility in capturing…
-
How can I calculate the average NETDAYS between 2 columns?
I want to calculate the average NETDAYS between these two columns as a field in my sheet summary. How can I accomplish this?
-
SUMIFS and referencing columns on another sheet
I've been searching the community and couldn't find an answer so hoping someone will see this and help.. I have a data sheet and am creating a calc sheet for a report. I want to look at the reference sheet, identify one "type" and then sum all the $ for that one type. I have tried different SUMIF/SUMIFS and I cannot figure…
-
Trying to get a dashboard to update with the most current entry.
I am building a weight loss dashboard for a client, that they can use for their clients. Everything is working how I want it to except for the current weight. I am trying to get that to update based off of the most current weigh-in weight that is added via the form. In the picture below it should be 180. I am trying a…
-
Sheet Summary Won't Count # of Cells with %
Hello, I have a sheet that has a column for % complete and I cannot get the formula in my sheet summary to count the # of cells that are 25%, 50%, 75% or 100% complete. The formula I'm using is =COUNTIF(Percent:Percent, "25"). This seems to work to count any that are 0% but none of the other numbers. What am I doing wrong?