Welcome!

Displaying formula sub-components values (Like F9 in Excel)

Hi all,

When having a long formula in Excel, I know I can highlight a part of the formula, press F9. The value of the subpart is then returned.

Is there some way to do something similar in Smartsheet ?

Best,

Hi,

Unfortunately, it's not possible at the moment, but it's a great idea!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Report Doesn't Have the Option for Grouping, Sorting or Filtering
I have a report that is referencing a control center program. Other users that are setup as leads on the program and have the same admin permissions I do are able to edit the Group, Filter, Summarize and Sort settings of this report, but I can not. When I click the Columns button it just says "Loading" and even if I leave…
Add additional items to existing formula
I wish to ADD the following to my existing formula: [Reporting Period]@row="Jan", "Jan" [Reporting Period]@row="Mar", "Mar" [Reporting Period]@row="May", "May" [Reporting Period]@row="Jul", "Jul" [Reporting Period]@row="Sep", "Sep" [Reporting Period]@row="Nov", "Nov" Here is my current formula: =IF(CONTAINS("-",…
Portfolio Gate Reviews
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…