-
Sheet Summary Formula - (status type) due in next 7 days
I have a manually altered date column [Next BHL Follow Up Date] and a status column with a few options such as "Give Reminder to Attend Appointment" How do I get a sheet summary that tells me the number of Give Reminder to Attend Appointment s are dated for the next 7 days? Thanks, Alix
-
How can I include comments in a portfolio view?
I'm hoping to use Sheet Summaries on project plans to roll all project information into a portfolio report, but one thing that I need is a way to have a 'status update'. We use comments and the conversation tab heavily in project plans, so I can pull a 'latest comment' column, but I want to pull comments made for the…
-
Merged: Sheet Summary Field - Add Format Painter Tool
This discussion has been merged.
-
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?
-
Enable sheet summary reports to be used in Data Mesh
Currently, reports generated using Sheet Summaries return an error message when attempting to use them in a data mesh configuration.
-
How Do You Document a Log of Notifications of Sheet Changes
One complaint that I am getting back from shared users of a sheet is that many times they don't know when something has changed. I can certainly make this manual task outside of the Smartsheet but I'd really like it to be captured in the sheet. For instance, I could use "File --> Email Shared Users" as the method to create…
-
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
