-
Count IFs or Sum IFS Formula
Hello all!! So currently trying to get a sheet summary formula to show the number of Dealer ID's that are not enrolled. Pretty much just need the number of Dealer ID's shown on the SS when the Enrolled Checkbox Column is not checked. There should be 162 Dealer ID's that are not checked but the formula I am using is…
-
Formula to get best poll time
I have created a poll with dates as column headers and several times as multi-drop down options. It created a fantastic web-form I was able to share easily with collaborators both inside and outside my organization. My question is, is there a formula I could apply in the Sheet summary to count the best time for each date,…
-
Merged: Organize Summary Fields - Add Drag and Drop to Organize Several Fields
This discussion has been merged.
-
Cumulative record of live sheet summary reports
Hi everyone, I have a sheet summary set up on every project, which tracks a number of weekly KPIs - e.g total tasks that week, total completed that week etc. The sheet summaries feed into a larger sheet summary report which shows these KPIs, but only for this week. I'd like to capture the info in the sheet summary report…
-
Hi, what is the best formula to collect a text in a range of column and return it into main column?
-
Summary Field return symbol for most recent entry
Hi, I've been searching and testing without much luck. I have a task list that the project health is updated with each task. I added a column for last modified date. I would like to have the summary field reflect the health on the row where the most recent modified date is. This summary field will be collected in a summary…
-
Can you call a sheet summary formula inside another sheet summary formula?
I have 6 sheet summary formulas. They are a sum of loads in that year over the 6 years those formulas represent. What im trying to do is calculate the percent changed year over year but it seems I cant call those formula returns into another sheet summary formula.
-
How to summarize data from multiple sheets without manually linking each cell?
Hello, I'm working on a project with KPIs that will be entered into ~50 individual sheets. I want to be able to roll-up these KPIs into one summary view, but am running into trouble when I pull them into a report because I can't perform calculations in a report. One KPI is Overtime %, so I can't just take the average of…
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Can I access/download spreadsheets I previously made without paying for the upgrade?
I no longer have the need to use the Smartsheet service but I would like to e able to refer back to the reports, sheets, etc. that I made while using the upgraded version. Is that not possible?
