-
Discreetly Alert Users When Summary Field is Present
The Sheet Summary Fields can be incredibly useful in providing sheet instructions or other sharable information to sheet users, however the summary fields are one of the best kept secrets for many users. It would be helpful if there was a means of discreetly alerting the user that Sheet Summary Fields were available. Even…
-
Merged: Able to use summary field from other sheet as a reference
This discussion has been merged.
-
Create Report Summary, Similar to Sheet Summary
There really isn't anywhere on a report to indicate what the report is about, or give instructions, or anything. It would be nice if there was a "Report Summary" very similar to the Sheet Summary functionality but for a report. Then we could add report level information for end users using the report. Even just a place to…
-
Naming Manager, Data Slicer, and Table reference functions for formulas, and LET, Unique, Sequence
Excel has leapfrogged Smartsheet in terms of ability to utilize data set, naming manager, dynamic data slicing, Dynamic Table formatting in excel sheets and new formula types LET used with Naming Once as reference, Unique provide back only unique values, Sequence able to order data values via formula, and several other…
-
AI text summary of a sheet progress/changes
Imagine you are a project manager, managing multiple projects/sheets. You have set up a dashboard that aggregates information from said projects. To make things easy to your CEO and other stakeholders, you'd like to generate a 500 word status report for each project that can be included per project on the dashboard via a…
-
What is wrong with this formula?
I am trying to summarize the quantities of each different sized container that is also checked as being shipped off-site to use in a dashboard pie chart. I tried the following formula, but I get '#unparseable'. What do I need to fix? Or coincidentally is there a better way, using reports, dashboards, however, to visualize…
-
Generate AI summaries for multiple rows at once
Currently, the AI text summary functionality is limited in that it needs to be run row by row. Can the functionality be updated to generate for multiple rows so that results are output simultaneously? This would result in a huge time savings. Thanks!
-
SUMIFS with sheet reference
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
-
Summary Field Descriptions
Feedback: summary fields are a fantastic feature for consolidating reports on the same view as the detail. It is challenging at the moment to document the purpose and intent of each summary field, unless one adds the description to the summary field name. Idea: Add summary field descriptions (similar to columns) that can…
-
COUNTIF Formula Error in Sheet Summary
Hello, Trying to use an existing formula in our sheet summary that is working for another column (dropdown list) in sheet summary. Not sure why it's not picking up the count for some columns and not others. The forumula's look the same and I've replace the column and cell names. Getting back 'unparseable' error. I've…