-
How can I calculate if a date is before or after another date field using Sheet Summary?
I want to count how many rows on a sheet have a date in one column greater than a date in another column.
-
Metric Sheet or Sheet Summary?
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 grids into a dashboard. I have created sheet summaries, and was using those to populate the dashboard, but have heard that…
-
Smartsheet Sheet Summary - Not Able to Show % in Sheet Summary using Join formula
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 dashboard. I have created a formula to show value (in percentage) whenever a checkbox is checked. This is working. Then I…
-
How do you create a report that counts the number of each status on a sheet?
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 change this report or create a new one? When I tried to create a new one my report builder looks completely different.
-
CountIF Formula issue
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]:[Issue Type], "Story", Labels:Labels, ISBLANK(@cell), Status:Status, "To Do", [Target Start Date]:[Target Start Date],…
-
Formula to Find Completed Tasks within One Month or Three Months
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 represent that information as a graph in a dashboard. Any help would be much appreciated! Thanks!
-
Count Multiple Items in the Same Column
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 to find the number of time two different values appear in the column. I've tried a few things based off questions here with…
-
Add =Formula to a SmartSheet Summary field
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 Project SmartSheet needs to pull in the ever changing status from the Master into the Sheet Summary added field. So that when…
-
What is the max number of fields you can put in the Summary section?
What is the max number of fields you can put in the Summary section?
-
Auto-Fill Rows of Data Based on Criteria
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 selected, the fields below would populate based on the values from another sheet. Example, If Austria is selected then the…
