Need help with If/then status formulas

Emily Reed

Hello!

I am trying to create a formula to show the status symbols for the projects I'm working on. The following formula keeps giving me an error and I am stumped.

=IF([Course 1 Due Date]@row), < TODAY(7), "Red" , IF([Course 1 Due Date]@row), < TODAY(14), "Yellow", IF([Course 1 Due Date]@row, < TODAY(30), "Blue")))

I am trying to do the following:

If the course is due within 7 days, I want the status to be red

If the course is due within 14 days, I want the status to be yellow

If the course is due within 30 days, I want the status to be blue

thank you!

Nick Korna

You don't need to close the brackets around the [Course 1 Due Date]@row in the formula.

This should work:

=IF([Course 1 Due Date]@row < TODAY(7), "Red", IF([Course 1 Due Date]@row < TODAY(14), "Yellow", IF([Course 1 Due Date]@row < TODAY(30), "Blue")))

Sample:

Hope this solves it for you!

Carson Penticuff

You pretty much had it, there were just a few extra comments.

=IF([Course 1 Due Date]@row) < TODAY(7), "Red", IF([Course 1 Due Date]@row) < TODAY(14), "Yellow", IF([Course 1 Due Date]@row < TODAY(30), "Blue")))

Emily Reed

I am still getting the error... Any other suggestions?

This is what was inputted this time -

=IF([Course 1 Due Date]@row) < TODAY(7), "Red", IF([Course 1 Due Date]@row) < TODAY(14), "Yellow", IF([Course 1 Due Date]@row) < TODAY(30), "Blue")))

Nick Korna

You don't need to close the brackets around the [Course 1 Due Date]@row in the formula.

This should work:

=IF([Course 1 Due Date]@row < TODAY(7), "Red", IF([Course 1 Due Date]@row < TODAY(14), "Yellow", IF([Course 1 Due Date]@row < TODAY(30), "Blue")))

Sample:

Hope this solves it for you!

Emily Reed

THANK YOU!!

Nick Korna

No problem, happy to have helped!