-
Mastering Parent-Child Row Relationships: Solving the '#INVALID DATA TYPE' Dilemma in Health Status
I am working on a sheet where I want the parent rows to reflect the health status of their child rows. I have defined four categories, which are "No Risks," "Some Risks," "Overdue / Risks," and "Canceled / Done / On Hold." I have created a formula to achieve this, but I want to establish a rule that only when ALL child…
-
If a value from Column A is found in Column B, can the occurrence be shown as "true".
Hello, I am looking for the easiest formula to help show when a value from Column A shows up in Column B. If it is possible, I do not want to enter each value found in Column A in a formula, as these values are actively changing. (Note: The list "Column A" is also extensive so manually entering each Active Project would be…
-
Sheet Summary Question
Hello all, I am trying to do a sheet summary to show the Active Dealers vs Non Active Dealers that are running campaigns. An active dealer will have a monthly total greater than 0. However the Monthly Total Column in the smartsheet is a referencing information from another smartsheet using a Vlookup. I am trying to do a…
-
Count of cells in the last 60 days with a specific status
Hi. I've been at this for hours and can't get it. I'm trying to write a formula that will pull a total count of items with a specific status for the last 60 days. Both of the formulas below work separately, but when I try to link them with an AND, it breaks. How do I link these two statements? =COUNTIFS([Enablement…
-
COUNTIFS WITH CONTAINS
I am trying specify counting only rows that contain "UO" within the Department column, are less than one year and the withdraw/rescind column is blank. I am able to achieve the counting of withdraw/rescind less than one year with the below formula, but when I add contain I continue to get the response #INCORRECT ARGUMENT…
-
Sheet reference Countifs formula with a date
Hello, I have a column that's a date and need a formula on a separate sheet to count if the date is current year. I haven't been able to find any community posts about sheet references, only cross sheet ones. Current formula: =COUNTIF({Date Column}, ISDATE(>2023)). I get an invalid ref error.
-
COUNTIF
Hello I am trying to create a count if function- My current sheet, Assigned Counter needs to return a tally with each "article" assigned to a trainer. So under the articles assigned i'm trying to use a countif function to return the number of articles assigned to a specific trainer. I am trying to use =COUNTIF(Request…
