-
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.
-
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…
-
Should a non-licensed user that is shared as an admin be able to see and use Work Insights?
I am a licensed Enterprise user and have added some Work Insights to my sheets. The sheet is shared to a non-licensed user as an admin. They are not able to see the Work Insights button on the right of the sheet or see the summaries in the sheet. What do they need to do to be able to see the Work Insights? Are only…
