- 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
你好,我想加几个清纯甜美TIF 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…
- 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?
- Hyperlinks in Sheet Summary not clickable when added to Dashboard as Metric Widget.
Is this intentional?
- 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…
