Nested If with Multiple Conditions Automation for Project Management

Hi SS Community!

Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me.

Currently, I have this:

=IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row)="Complete"), ([Status]@row)= "In Progress"),"On Deck", "Not Started")

I just need to automate

If the start date is within 2 weeks and the status is not complete or in progress, then mark it as on deck.

Otherwise, default to not started.

Thanks for the advice in advance!

Find more posts tagged with

Manufacturing

Calendar View

Formulas

Marketing

Conditional Formatting

Comments

L_123

You prematurely closed off your or statement and didn't close the not afterwards

=IF(AND([Start Date]@row < (TODAY() + 14)), NOT(OR([Status]@row="Complete", [Status]@row= "In Progress")),"On Deck", "Not Started")

L_123

=IF(AND([Start Date]@row < (TODAY() + 14), NOT(OR([Status]@row="Complete", [Status]@row= "In Progress"))),"On Deck", "Not Started")

You also prematurely closed your and statement. Missed that in the first answer.

Kristina Howes

Hmm, it says that it's a circular reference. Any way that I can fix this? I am putting this in the column titled "Status".

Thank you!

L_123

You can't reference the current cell for a value, then change that value. I think your best solution is to add another column to have this work properly.

Sign in to join the conversation!

Quick Links

Trending discussions

Calculate Project Time TOTAL for PM across aligned projects
Hi - I am trying to figure out how to create a SUM of the Total Project Time aligned to each PM for all of their projects. On my master sheet I have the Resource Type, Resource Name, and a Helper Column for Time. The Helper Time is an estimated allotted time based on the timeframe of the project. Example: <3 months = 25…
How to Create Time Duration
I have a report where I need a formula to figure out time duration. For example, employee starts at 8:00 am and ends at 9:00 am, I need the next column to tell me 1.00 to indicate he worked 1 hour. I will be using military time throughout this sheet.
Formula with range data
Hello, I'm looking to see if anyone knows a formula that would add owner income and co-owner income together to reflect in Joint Income column. I'm not sure how to do this with data in ranges. Thank you.