-
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…