-
Join/Collect across sheets
Hello, I think I am really close with my formula, but still getting an unparseable error. =JOIN([Freelancer's name]@row:{Feedback Range}, COLLECT({Feedback Range}, {Audition Status Range}, [Audition Status]@row), "'s ") I have a source sheet (Feedback) that contains 3 different feedback text, for three different Audition…
-
Removing Condition if the Value is blank
I have a formula that shows the Status of a milestone and it currently reads the due date (Finish) and automatically updates to off track if the due date has passed and the status if not in at risk or completed. However, I cant seem to get the formula to the point where it will not mark the milestone as off track if there…
-
Is anyone else having trouble with the Today function?
Hello, The Today function is not working when included in a simple IF statement. It was actually working a while ago but now it is not working. I tested it out by simply trying =IF(Cell@232="2",=Today(),"") but it would spit out #INVALID OPERATION. I have even tried =IF(Cell@232="2",Today(),"") but it would spit out…
-
Count, Children, Status
Hello, I wanted to create a report/dashboard that showed the total number of items under a parent and how many of those items were in a non-green status. I am entering my formulas on the Sheet Summary section. I have created the formula for count of children but am having a hard time showing count of those children with…
-
Formula Error/Mistake
Hi all, I have a formula that autopopulates only certain cells. Now, it works fine in my other sheet, however, I had to do slight adjustments to it in this sheet and it clearly populates the correct cells, however, it is not giving me the correct value, and instead just puts 0.00. Can some please help me figure out the…
-
Can you match between multi select dropdowns?
I'm trying to match values between two multi drop downs. In one sheet there are rows that are associated with multiple groups, in the summary sheet are the groups that are selected. Is there a way to write a formula that will look at the summary values in the dropdown and see if any of those values exist in the second…
-
Returning a value based on multiple criteria
I am trying to autofill a summary table using formulas. I am able to autofill the monthly counts using date criteria, but I can't get the total numbers to autofill. I tried using the below formulas to pull from the two places where I have the counts for total members and total new members of each member type, but I keep…
-
Count and provide unique numbers
My need is to provide a unique and incremental number for each row, so when a new item is added it gives it the next number in that category. The current formula is =COUNTIFS(Created:Created, <Created@row, Type:Type, Type@row) + COUNTIFS(Created:Created, Created@row, Type:Type, Type@row) However, because it's based on the…
-
TEXT to DATE Formula
Currently we are using an API to upload a "date" into our sheet, but can only upload it into a text column without causing errors with the API. To transform it into a date column, I have created another column that uses a formula to covert the text uploaded into a date format. However, I'm having troubles simplifying the…
-
Countif and Contains formula
Hello, I am needing a formal that counts items that are the following: Range 1 = Consultation Range 2 = Completed Range 3 CONTAINS Ute Mountain Ute Tribe The below is what I have, but it says it is umparseable. =COUNTIFS({CDHS Tribal Team Range 1}, "Consultation", {CDHS Tribal Team Range 2}, "Completed", ({CDHS Tribal…