-
Hide Sheet Summary Fields
I have a sheet with information added into a sheet summary (i.e. not pulled in to the summary from the sheet). I use the summary fields as high level project information. This allows me to pull these fields into a summary report. However, for one field, I want to use it as a filter in the report - but not have it visible…
-
Countifs where sheet range is formula returning a number and criterion is sheet summary dynamic drop
I have a column called '"Wave" which shows a number 1-10. The value is returned on some rows from a =PARENT formula and on some rows it's hardcoded. (I understand it should be either formula or hardcoded but go with me here...) I have a sheet summary which works perfectly well when the 'Wave' column in my sheet is…
-
ODBC connector doesn't expose Sheet Summary data
In testing with Tableau, we found that the ODBC connector doesn't expose data from the Sheet Summary reports. That really reduces the usefulness of the Summary for enterprise integration.
-
How many formulas can a sheet summary hold?
I have a sheet with a hundred some formulas and I will probaby have 200+ at the end of it. Will I have any issues with that?
-
Auto move sheet to another folder after few day
Hello ! i have question: we have a lot of smartsheet to capture information, but many of them have no update in more than 30 days, is there any feature that auto check these sheets, which have more than 30 days no update and move to specific folder ? Thank you
-
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?