-
COUNTIFS for Children Rows
Please help This formula works for Countif and .. =COUNTIFS(Status:Status, "In Progress", [Client Report]:[Client Report], =1) When I add in the Children to restrict the formula to children tasks I get an unparseable error ..please help..what am I doing wrong ? =COUNTIFS(CHILDREN(Status:Status, "In Progress"),…
-
#Invalid data type - Countifs on two category's.
Hi, team. Difficulty in nailing the formula.. Sourcing data from our Design sheet I'm trying to count for each of our sales team members how many requests they have lodged (10 requests types) & of those how many of them are at each status (7 types). IE, I could have 10 at Drawing only& of those 4 at "In Progress", 2 at…
-
Setting up the best formula
Hi all Can someone please help me. I am new to setting up formulas and have been successful in doing a number of them on my smartsheet already however for some reason my brain has gone dead and I cannot figure out a formula. I have a column which is a checkbox, I want a formula set up to notify me how many have been…
-
COUNTIFS - Referencing two columns
Hi - I keep getting an UNPARSEABLE error with my COUNTIFS formula. My intention is to have a summary of how many documents are pending approval from another department - I need to return a count for how many rows have a date included in the "Date Submitted to OMB" column, but are missing a date in the "Date Returned from…
-
Index Match Formula with Multiple Criteria?
Hello, I'm trying to create an index that has multiple criteria. I'm not sure if I should do this using an "IF" formula, or if I need to incorporate the "AND" function into the formula. Or if I need to go in another direction to accomplish this. What I need to do is return the "Rate" based on the "Crew Type", and the…
-
How to make a change in smartsheet after a workflow has already been executed?
I have a workflow that sends data from one sheet (A) to a second sheet (B) - this workflow is executed when the completed column changes to checked, using a checkbox. So, once the checkbox is checked on sheet A, the data moves to sheet B. There are times when the data needs to be updated or changed on sheet A and I can't…
-
Need help with complicated formula
As usual, Im having a hard time developing a complicated formula. @Paul Newcome helped me last time with a great solution. Im hoping someone can help untangle the webs for me. I have a sheet that has (among other things) a Date column, another column with a formula that determines a number of days, and a month number…
-
Formula Countifs
Hi. I need to write a formula in my Sheet Summary report. How do I add other countries on my counting.... all countries below belong in one category "South America" =COUNTIFS({JoseTracker Range 7}, "Argentina"......... Argentina Brazil Chile Colombia Mexico Peru
-
Programme level reporting - cell linking Vs. sheet summaries
Hi, I'm building programme level reporting which spans about a dozen projects. At the moment, I'm testing two routes - 1. sheet summaries and then a sheet summary report, and 2. cell linking. Cell linking is looking like the preferred option because sheet summaries aren't dealing very well with percentage formatting, at…
-
Format number as a % percentage on sheet summary?
Hi, it is possible to format a number as a % on a sheet summary? I'm simply referencing one cell in the sheet, but the number it returns is 0.5462, rather than 55%. The problem is that the decimal format then feeds through into a summary report.