Could someone explain the differences and benefits of using a metric sheet or a sheet summary? I have a project that has several grids, reports, and dashboards, and I need to add some metrics from the…
Hi All, Hope you all are safe and well. Question : Is it possible to show a percentage (%) in my sheet summary by using a =JOIN formula? I would like to use this so I can use the metrics widget in the…
How do you create a report that counts the number of each status on a sheet? I want to create something similar to this template but with my actual statuses not these preset ones. How can I either cha…
Greetings, I'm currently attempting to create a CountIF function that counts the number of Ungroomed Stories that start within the next 30 days. My formula is the following: =COUNTIFS([Issue Type]:[Is…
First post, pretty new to Smartsheet, need some assistance with a formula. I'm trying to Create a Sheet Summary formula to calculate the amount of Tasks completed within a month and quarter so I can r…
Hi Smartsheets Team, I am trying to write a formula to count the number of rows in a column to sum up the amount of times two different values appear. To clarify, each row has one value. I am trying t…
Hello, How can I add an =Formula that would update based on a source SmartSheet? What I need to do is. We update a status of a project on a seperate Master SmartSheet for tracking. The individual Proj…
Is there a way to have the Sheet Summary auto-fill multiple values based on a selection from a drop-down field? I would like to have "country" be the drop-down select field and based on the country se…
Hello, I have two separate column Status and Due Date and I'm looking to create a formula on the sheet summary for the amount of items that are due today and past due. Is there a way to create one?