-
Sheet Summary fields not showing all data on Report
Please see the image. For some reason some sheet summary fields are not displaying on the report and others are. All are visible when I view the fields from the report. I've tried moving the sheet to a different workspace and folder, changed the values in the fields, etc., nothing works. Why are the green showing just fine…
-
Why isn't my COUNTIF formula updating?
I am using the COUNTIF formula to keep track of quarterly reporting status for clients. For example, I need to track how many clients have a "failure to report" status. The row that I am pulling the data from is a dropdown selection - which I have never had issues with before now. When I plug in the formula, it registers…
-
Use of sheet summary fields (or formulas) in automation
It would be great to be able to include calculated values and/or sheet summary fields within automation. In general, the point is including global conditions in the automation criteria. An example is an employee calendar with daily alerts as to who is out of the office. When people are out for a range crossing a…
-
Custom Columns in 'Sheet Summary' Report
This report is amazing and could be super useful if we have the ability to customize the column names according to our team's/organization's needs. The columns in the 'Sheet Summary' report get auto-generated and are not based on the source sheet(s). We need to be able to customize these as my team uses different legends…
-
Find the most recently passed Thursday based on Today's date
I want to count the number of project manager status update sheets that are not updated to the most recently passed Thursday. All the project managers are supposed to update their status update sheets every Thursday. On the following Sunday/Monday, I will check and see which status update sheets are not updated to the most…
-
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.
-
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…