Sheet Summary
Discussion List
- 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 w…
- 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 ind…
- 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_l…
- 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(),…
- 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?
- 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 Channe…
- I need to create a Summary Report for multiple fields on one sheet. I am successful in getting the COUNTIF statement to work on one of the columns, but when I add fields for a different column, the co…
- I'd like to create trend reports on project data over time. For example, I use a sheet summary to total completed story points for a project. I update the project metrics in my sheet every 2 weeks. I …
- Is there a way to get a list of all of the sheet summary fields in a sheet with their formulas? For example SummaryField1 = COUNTIF(Field1,="1") SummaryField2 = COUNTIF(Field2,="2")
- Hi! Thank you for considering this problem, I am very new to Smartsheet. I have a form that I have 10 regions complete monthly. There is a due date for each month. I would like to generate a report of…
