Sheet Summary
Discussion List
- =COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress") That formula is to count the number of cells that have "Now (1/1/…
- Hello! I've tried to add a formula to convert an existing column into one with a formula and none are working. I have a target end date and i want existing cells in a "task section" to calculate the w…
- Hi all! I am trying to create a formula that compares 2 values in the same column. One on the current row, to one on the row right above it. Every row represents a separate week, and I want to compare…
- In my Sheet Summary, I am using the formula =SUMIFS(Shipped:Shipped, [Date Manufacturing]:[Date Manufacturing], YEAR(@cell) = 2023) + SUMIFS(Pending:Pending, [Date Manufacturing]:[Date Manufacturing],…
- Hi, Can you tell me how to link field from summary sheets into a cell on a different sheet in Smartsheet? I have seen other chats on using helper columns, but nothing that provides guidance on the pro…
- Hello. Smartsheet allows me the add the "Total Amount of Cash" text/number column and generate the contents of each cell (bottom snap). When I try to create a summary for that column (like the "Total …
- Hi all, Need a bit of help with constructing a formulae to input into a sheet summary box for the below situations: To calculate the count of 'Medical Device Related' category from the 'Relevant Syste…
- Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I a…
- How would I sum more than one column based on a Date of Manufacture column? I want to sum three different columns based on a year of manufacture column Thank you..
- I have a few sheets that I need to copy this formula into the Sheet Summary. The formula works in the original sheet (it was AI generated through Smartsheet). When I copy it to the other Sheet Summary…