-
Enable Cross Sheet References to work with Sheet Summary
I check with Smartsheet to see if this was possible and it is not. I've submitted an enhancement request. Support suggested I post the idea to the Community so folks could "like/vote for" the idea. If by chance someone knows how to do this...reference sheet summary values from another grid, or between sheet summaries on…
-
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…
-
Editable Sheet Summary Report
It would be a good addition to Smartsheet to be able to edit data in Sheet Summary reports, just like we can edit regular Row Reports. I don't understand why the 'two-way' data entry functionality between Sheets and Reports does not apply to Sheet Summary fields.
