-
Trying to anchor formula to specific row
Hi, I have entered this and it works: =IF(FIND([SOP Required Group]1, [SOP Required Group]@row) > 0, "Y", "N") but if I want to anchor to Row 1, I get an #unparseable error: =IF(FIND(SOP Required Group1, [SOP Required Group]@row) > 0, "Y", "N") What am I missing?
-
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…
-
Automation notification or email not coming through
Hi! I wanted to have an automation notification set up that when "form uploaded" is checked, it notifies the person in the "manager" cell. I've tried to adjust my automation two different ways, see screenshots below. Simple enough, but it isn't going through.
-
Using a countif formula across sheets
Hi, I keep getting different error messages when I try to use a countif that draws from different sheets. My goal is to keep a running count of how many calls each team-member has taken this year. We usually use up to 4 sheets a year tracking calls and I want to track the total number. This is what I am entering: ="Bocquet…
-
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…
-
Incorrect Argument Set
I am running in to an error on a metric sheet i have created which has me stumped. On some cells it is working and on others I am getting #INCORRECT ARGUMENT SET I have literally just dragged the formula. and if I change my $[SOURCE FROM]$2 column to another branch, different cells in the bottom snip show #INCORRECT…
-
Multi Step Formula - Monthly Counts
I'm trying to create a metric sheet that looks at multiple values, and records that info in a cell each month. If I have 5 members join membership A, in October 2020 it would count the member type + number of members in the month of October 2020. Once I nailed down the proper formula I would apply it starting Jan 2019. I…
-
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…
