-
COUNTIFS in Sheet Summary utilizing a Contact Card column
I am trying to create a sheet summary, where the field is a formula that relies on a contact card within a column. However, it keeps returning a result of "#NO MATCH". The columns involved are, 1:) Priority (symbol column) for Up, Unchanged, and Down, and 2:) Contact Card column. I am trying to get a sheet summary formula…
-
Timeline & Portfolio Visibility for Multi-Project Reporting
Hi Everyone, I’m exploring whether Smartsheet can support a portfolio-level timeline view for our leadership team. I’m aware of the Timeline feature, but I’m looking for something more flexible and consolidated. Ideally, project managers would be able to select specific milestones or key tasks to surface on a shared…
-
Sheet Filters > Feed Sheet Summary Fields
Saved filters to give the option to feed into sheet summary fields (and option to choose which ones go into the summary field along with their titles). Ideally I would like it to be dynamic. So if you change the filter name or parameters in the sheet, the summary fiels also changes
-
Emailing Summary Reports With Summary Details
Currently when an automated email is setup for a report, the attachment in the email will not include any summary data you have setup in the report. It would be fantastic to be able to have that included.
-
Sheet Summary in Table View
We love the dynamic drop downs in table view, however we can not roll it out across our sheets due to existing sheets still having summary fields that are referenced. Is there a way to just have the summary fields visible on the table view?
-
AVERAGEIFS or AVERAGE(COLLECT()) Help
Hi! I am struggling to get this formula to work correctly. The Smartsheet-AI generated formula is returning #UNPARSABLE and I am not too familiar with Average Collect. The goal: Average the column "Total Days Open" if the following criteria are met: column "Business Type" is NOT "retail" and column "Division" is "Northern"…
-
Countif for Days Elapsed between two dates
Hi - I have a tracking sheet - it logs date when we receive a request and then a date when the request is fulfilled. I need to calculate how many rows in my sheet where the date rec'd to date of completion is 5 days or less - I'm doing this in a Sheet Summary field. I asked the AI for a formula and it gave me this:…
-
Sheet Summary: allow multiple select dropdown
Current behaviour: Sheet summary dropdown only allows for single select Requested feature: Sheet summary dropdown allowing for multiple select Case: We currently use the sheet summary side panel to put all general project information. For many different fields, such as Project Scope/SKUs, it should include multiple select.
-
Sheet Summary changes overwritten by other users - can this be prevented?
I have a sheet that has sheet summary values I occasionally need to update the formulas for as factors change however I've found that when other users are updating the sheet (it's a testing sheet) the changes I make to sheet summary formulas are overwritten as those users update their test statuses. Aside from making the…
-
Sheet Summary Grouping
Allow for grouping content within Sheet Summary window that can expand and collapse.