-
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…
-
Sheet Summary Formula for Due Dates
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?
-
Auto Create Parent Child Hierarchy
Hello Smartsheet Community, I am planning on sending out a form periodically (every 2 weeks) requesting certain users to feed in the tasks they have performed for that period. I was hoping to set each response as a child row, while the period to which the form relates as a parent row. Is there a way to set an automation…
