-
How do I count the number of parents in a column?
I want to count the number of parents in a column, I am able to count the number of children and descendants using, =COUNT(CHILDREN([Primary Column]:[Primary Column])) and =COUNT(DESCENDANTS([Primary Column]:[Primary Column])). When I try to do the same to count the parents, =COUNT(PARENT([Primary Column]:[Primary…
-
How do I count how many columns are in another smartsheet?
I've ran into issues with cell limits, so now I am trying to create a summary sheet of all of my smartsheets that would calculate how many columns are used in each smartsheet. I've tried adding a [First Column] and [Last Column] in the actual smartsheet I want to count, then used this formula: =COUNTIFS([First…
-
Countdown formula based on column calendar
I am using the sheet to track waste. I have a column that is the Accumulation Date based on the calendar option imbedded in the column which changes depending on the day the waste is input. I need my next column which is Days to Shipping to reflex the days since the waste was input. I will then conditionally format the…
-
Why won't grouped report show details?
I'm getting so frustrated with a report! I want the rows grouped by deliverer (Primary column) then by category. But I need the viewer to be able to expand each group to see the details. For example, a manager can get a count for how many sessions were delivered by a particular person per PD category, but then can expand…
-
Reports Filter Criteria Behaviour
Hello Exports, I am building a report based on a source sheet. The report should extract the rows based on the criteria "This Week". Can you please take a look the pattern of screenshots and confirm if this is an expected behavior ? The data's appearing only when I am using "Is One Of" but not the other conditions. The…
-
Formula and Function : COUNTIFS : Invalid Data Type (Cross Sheet Referencing)
I am working on some key metrics for one of our teams that track referrals. I am getting an Invalid Data Type and I know it is due to "blank cells" in two of the columns I am looking at. ISBLANK is not my strong area and unfortunately I cannot generate the formula using the AI Tools because it is not capable of cross sheet…
-
Count and Countif Formula adding 4th Statement
I have an existing formula: =IF(COUNT(CHILDREN(Status@row)) = 0, " ", IF(COUNTIF(CHILDREN(Status@row), "In Progress") > 0, "In Progress", IF(COUNTIF(CHILDREN(Status@row), "Complete") = COUNT(CHILDREN(Status@row)), "Complete", IF(COUNTIF(CHILDREN(Status@row), "Not Started") + COUNTIF(CHILDREN(Status@row), " ") =…
-
Forumlas that have shading to alternate every other row which also update when rows are deleted/adde
Good afternoon! I did use a pair of formulas based of digging I did on the forum, both a =ISODD and =MATCH, with an AUTOID column, but I think I'm making it harder. This sheet is based off a form which will add a row per submission. I'm wanting to alternate the shading every other row via conditional formatting, which it…
-
"IF" Formula Question with Symbol
Hi, I'm trying to write an equation so that my "% Complete" Column tells my "Progress" column to either be an empty circle symbol, a half circle symbol or a full circle symbol. There are only 3 options in the % Complete column: 0%, 50% and 100%. But I can't get anything to work for my Progress column outcome. See attached.…
-
How can I show the assignee of a parent task based on the current active sub task assignee?
I would like a parent task to show the assignee based on the subtask that is active at a current time. Is this possible? Ideally the task being active would be defined if the todays date is between start/finish dates. For example: Task 1 - Assignee = X Task 1.1 - Assignee = X - In Progress Task 1.2 - Assignee = Y - Not…