Need help with If/then status formulas

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!

Find more posts tagged with

Accepted answers

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!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.