Sheet Summary
Discussion List
- Maybe a dumb question but I can't figure out how to do it or if it can be done by searching on the Community. I have a source sheet of client data that's summarized into 3 Summary fields by the assign…
- I'm trying to pull in expenses tied to a specific category and based on a specific month. I've been trying to make this formula work but keep running into "Incorrect Argument Set" and "Unparseable" me…
- Here is my formula: =COUNTIFS([Plan of Record]:[Plan of Record], FIND("2023", @cell) > 0, [Request Status]:[Request Status], NOT(CONTAINS("Cancelled", @cell), NOT(CONTAINS("Merged", @cell), NOT(CONTAI…
- I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index…
- The ability to copy an existing sheet summary field and edit to save with modified formula.
- This is the error I'm receiving on my sheet summary page. Please note that the sheet is "set up" with columns and necessary formulas, there is just no information entered yet. Every time I open this s…
- I'm trying to create a Sheet Summary field formula that will count up the number of "Yes" (formula-generated, if that matters) cells in a column if the date, in another column on that row, falls withi…
- I have an expense 'tracker'. Essentially it tracks if employees submitted their expenses (1) correct the first time; (2) expense was sent back for revision; (3) submitted late (4) did not submit My co…
- I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns …
- Hi All! I'm trying to use the Summary in a sheet to tabulate an object count between a date range. I'm trying to get a Sum of cells in a column "Number of Objects", if the "Date Imported" is between a…
