Need help with a formula to look at multiple columns and insert a value in another column.

Currently I have the following formula in the Grant Status column to indicate active or inactive based on the end date. Now I need to add Deactivated as a status based on if the FY Start is NA. If NA is the value, then Grant Status needs to be deactivated regardless of what End Date is, whether blank or has any value. Everything I've tried is always incorrect.

=IF([End Date]@row = "", "Active", IF([End Date]@row < TODAY(), "Inactive", "Active"))

Find more posts tagged with

Accepted answers

Paul Newcome

Give this a try:

=IF([FY Start]@row = "NA", "Inactive", IF([End Date]@row = "", "Active", IF([End Date]@row < TODAY(), "Inactive", "Active")))

All comments

Paul Newcome

Give this a try:

=IF([FY Start]@row = "NA", "Inactive", IF([End Date]@row = "", "Active", IF([End Date]@row < TODAY(), "Inactive", "Active")))

Delilah

It worked. Thank you. This is pretty much what I did but must of have some punctuation wrong or wrong order.

Paul Newcome

Happy to help. 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.