-
Nested if statement not working, am I doing the formula wrong or is it not working correctly?
Hi all - I am trying to do a nested if statement for an approval chain but I can not get it to return a value different than #UNPARSEABLE. Can someone check my formula and tell me where I am going wrong? =IF([Cell 1]@row = "No", "Rejected", IF([Cell 1]@row = "More Info Needed", "More Info Needed", IF([Cell 1]@row = "Yes",…
-
Workflow condition starts with < N
We have a use case where an assignee is variable based on an ID 'number.' The ID Number starts with a letter code, and the assignee is IF ID starts with A-M THEN AssigngedTo = User1@domain.com ELSE AssigngedTo = User2@domain.com Clarification: A-M is A through M
-
COUNTIFS Formula not picking up additional rows
I created a COUNTIFS Formula to tabulate results from a column containing responses from a Multi Select Drop Down Form. Once I go the formula right, it calculated correctly but as additional rows have come in to the sheet, it isn't picking up those additional rows. One cell is still showing the original value, though based…
-
Consolidate unique values from multiple columns into single column
Hi all, I was curious to know if there was a way to extract the unique values from columns and consolidate it into a single column? For some context, we have individuals under different columns based on their position and location, similar to this screenshot (location through manager) The roster I actually have on a…
-
DISTINCT COUNT BY DATES
Hello, All. I'm new to Smartsheet and trying to find a formula that can pull unique/distinct names by date. For example, one employee can complete multiple reviews per date. I need to pull the total volume of reviews (Date of Review) by employee (Call Reviewed By). So, total reviews for each day for each employee.
-
COUNTIFS not resulting in same count as filter
Hi all, Strange situation over here...I am looking to count the number of cells with the word "waste" in a column called Narrative. I started just by filtering the data to understand what volumes I would get. Then I decided to use a formula to pull this data onto another sheet: =COUNTIF({2021 Q3 Narrative}, FIND("waste",…
-
Percent Complete from an External Reference
Hello! I'm working on a project plan for work and have external references to another sheet. I'd like to accomplish a count or countif function to help me with the below: If "Column X" = "Y" then count the sum of "Y" in that column and divide it by the total rows for a percentage complete. Meaning, I want to count the…
-
INDEX/COLLECT returns #UNPARSEABLE error
I am trying to pull PO totals over from one sheet to another where unique Claim ID numbers match that are present in both sheets. However, I keep getting the #UNPARSEABLE error msg. Formula: =INDEX(COLLECT({PO Value},{PO Value}@cell <> "", {Claim ID}@cell = [Claim ID]@row), 1) 1) {PO Value}: this is the source range that…
-
Index Match contact list and automated emails problem
Hi good morning. I have a issue with one sheet that i created and specific with a column that return me an email with an index match formula. What we try to have is a contact person if we choose the Director or that business. i.e. Director is John Doe and the formula return in other column Lead email…
-
AverageIF or Avg(Collect) formulas
Hi All, I have multiple criteria and thus used the AVERAGEIF statement, however, this is not working cause this formula only limits to one criteria, and I need to add multiple criteria. For example, we are able to do this with COUNTIFS statement, however, there is not AVERAGEIFS statement. Since AVERAGEIF is not working…