-
IF statement (Inventory status updated from "order needed" to "reordered")
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
-
Inventory Status: Reordered (How do I do it?)
Hello, I am developing an inventory reorder system and I need the status of the line item to show "Reordered" when the check box is checked under "Order Status" I recognize that there are multiple true statements within my formula so how can I show "Reordered" while the stock quantity is below the ROP? I have been trying…
-
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…
