-
=IF(AND(OR(HAS Column Formula with 3 results (option 1, option 2, both) #INCORRECT ARGUMENT SET
I have a search range which is a column that has up to 35 bus routes. The bus routes are operated out of one of two facilities, "ARCADIA" and "POMONA". I am trying to create a column formula that will return a result of "ARCADIA", "POMONA", or "BOTH". I can successfully create a column formula that will return one of those…
-
Summary Sheet & Filter based on Form Responses with Multi-Select Dropdown
Hi all! Hoping for some assistance with a summary formula pulling in criteria from a multi-select dropdown response form... I have a dashboard that has a form embedded in it to allow the user to enter their desired criteria (see below screenshot) and then the bottom of the dashboard pulls in the metrics using the form…
-
If then/or /and with subtracting
Hello, I am trying to figure out a formula to subtract if Travel day = 'Yes' to subtract Submitted HRs - Lunch time, but then also subtract Submitted HRs - Lunch time - Contracted HRs if Travel Day = 'No'. Bearing in mind that Submitted HRs and Contracted HRs have formulas to get their values.
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…
-
If Function for Drop Down
Hi Im looking for a formula in my sheet where if i select a drop down in one column it will give me a selection of drop downs in another column eg column 1 - if Commerce is selected column 2 - commerce, short breaks (drop downs) only eg column 1 - if guest is selected eg column 2 - guest, guest data drop downs only thanks
-
Combine two IF formulas
Can someone kindly help me combine these two formulas? It's too complicated for the AI formula generator. :) =IF(MONTH([Global Trade Compliance Approval Date]@row ) = 1, "January", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 2, "February", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 3, "March",…
-
IF Formula and Auto Numbering
I'm looking to use the below formula however I get an 'INCORRECT ARGUMEMT' error message: =IF(Type@row, "Form", "F-" + [Auto #]@row, IF(Type@row, "Report", "R-" + [Auto #]@row)) Additionally, I'm looking to add this funtionality to a sheet that already has some R-XX and F-XX entries, and looking to automated the numbering…