-
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 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.
-
How to access Sheet Summary from within the Table View?
Hi Does anyone know how to access Sheet Summary from within the Table View? I know how to access it from the Grid view but have also heard that soon the Grid view will be removed permanently. My project requires a lot of dependence on the sheet summary so it's important for me to know the safest way out. Thanks
-
Modify Sheet Summary field
Currently have a field in my sheet summary with this formula: =COUNTIFS(Finish:Finish, <=TODAY(+14), Finish:Finish, >=TODAY(), [Helper Parent Column]:[Helper Parent Column], <>"", Status:Status, <>"Complete") I would like to add if the Status is "Not Needed". How do I modify the formula?
-
Rearrange Sheet Summary Fields - click and drag
Moving summary fields one position at a time is cumbersome and unnecessary. Please add functionality to those fields to allow a user to re-arrange and/or sort as desired.