-
Return a value when one date is less than another
I'm trying to project the amount of non-bill hours we plan to spend on a project between the non-bill approval date and the contract end date. I'm getting an invalid operation error when using this formula: =IF([Column2]1 <= [Contract End Date]@row , [Approved Hours per week]@row , "") Here's my column setup: I've…
-
Formula for impact score x likelihood
Hi i currently have the below formula but need help amending this =IF([Impact Score]@row = "", "", [Impact Score]@row * [Likelihood Score]@row I need to amend this for if column type is risk then impact score* likelihood score and if column type is issue then return impact score only Thanks
-
Multiple if statements with And and Ors
I have multiple Ifs and I seem to have tied myself in a knot. =IF(NOT(ISDATE([Earliest Day 180]@row )), "Red"), IF(AND([Send HIE]@row = "Green", ePrescribe@row = "Green", [Receive & Reconcile]@row = "Green", [Provide Patient Access]@row = "Green"), OR(PHCDE@row <> "Green", [Query PDMP]@row <> "Green"), "Blue"),…
-
#INVALID DATA TYPE on an IF( function
I have a formula that I'm trying to get to solve the following situation: If someone has worked for less than 2 years (<730 days), the "destroy on" date should be their hire date plus 3 years (ex. hired on 1/13/2021, destroy on 1/13/2024). If someone has worked for 2 or more years (730+ days), the "destroy on" date should…
-
Formula Help
I am seeking assistance with a specific formula. I am creating an employee snow deactivation request and tracker. Employees can schedule time off during winter operations. The issue is that we have two periods, Preseson and In-Season. The Preseason period to submit your vacation is 7/15/25 thru 8/15/25 and In-Season is…
-
=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…
-
My IF Formula only works in certain cells in my grid
I have a formula in my sheet that sums the hours by project, phase and category. Ie for a row with task 1 I get the sum of (1) total hours logged on timesheets, (2) Design Engineer Hours (2) Senior Design Engineer Hours, and (3) Principal Hours. The formulas are as follows: Total Hours: =IF([Budget:]@row > 0, SUMIFS({TS…
-
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
-
If Condition
I have this condition which works well (copied from line 89 of my plan) =IF([% Complete]89 = 1, "Complete", IF([% Complete]89 = 0, "Not Started", "In Progress")) I'd like to add two conditions: 1st: if the %complete is 90%, then the cell should change to "Scheduled" What I thought would work: =IF([% Complete]85 = 1,…
-
Using If/or/and to change date based on different drop downs and checkmark selections
Hi all, Adding on to an existing formula to automatically add a number of days depending if a column is checked or not. The bone column is either "NA" or various types of bones which populates the final date in the QC column based what is selected. I'm trying to add if the Timeline extension box is checked, it will add the…