Formulas

I'm Trying to add a function to the following formula in which adds "should the cell to the right of this formula show anything else except completed then the formula will display BEHIND

=IF(AND(TODAY() + 1 >= [Completion Due Date]29, [Days to Completion]29 < 100), "BEHIND", "")

Find more posts tagged with

Formulas

Comments

Mike Wilday

Try this:

=IF(AND(TODAY() + 1 >= [Completion Due Date]@row, [Days to Completion]@row < 100, Status@row <> "Complete"), "BEHIND", "")

This should fire IF and only IF - Today + 1 is greater than or equal to the completion due date AND Days to completion is less than 100 and the status row doesn't say complete.

RotorYacht

You are AMAZING!! Thank you so much it worked!! I'll buy you a beer!

Thanks,

Jay

Mike Wilday

Lol. Sounds good. Glad I got it working for you.

Paul Newcome

?!?! How come no one ever offers to buy ME a beer?!?!

Hahahahaha

Mike Wilday

Sign in to join the conversation!

Quick Links

Trending discussions

Sheet Countdown Timer
Happy Thursday. I know many have asked this question before, but does anyone know of a way to have a column actively countdown time? Even if a plugin is needed, it will be considered. Here is what I'm looking to do. When a form is filled out and a new line is added to the sheet, I'd like the "Countdown Timer" column to…
Formula for populating date
I am needing a formula that calculates Termination Date (date property). The formula needs to look at Initiation Date (date property) and Term (text/num) which is based on # months, to calculate Termination Date. In this example, the termination date should return a value of 1/01/26. Thank you!
INCORRECT ARGUMENT SET on an =IF function
I'm trying to pull in the contact information of a second HR Business Partner, contingent on the department of the individual, from a separate reference sheet. However, not all departments have a second HRBP— so if the column of "second HRBP contact info" is blank, I don't want anything to be pulled into the new sheet's…