Combining Two If statements

Emily Reed

Hello!

I am trying to combine the following two if statements and every time I try, it gives me an error.

=IF(NOT(ISBLANK([Date Submitted to AP]2)), "Yellow")

=IF(NOT(ISBLANK([Fulfillment Receipt Received]3)), "Green")

Any help would be greatly appreciated!

Find more posts tagged with

Accepted answers

Paul Newcome

Happy to help.👍️

All comments

Paul Newcome

Try something like this...

=IF([Date Submitted to AP]2 <> "", "Yellow", IF([Fulfillment Receipt Received]3 <> "", "Green"))

Emily Reed

Hello Paul!

I tried that and did not get an error, but it only recognizes the yellow if statement.

Emily Reed

Oh, I got it to work by flipping the colors -

=IF([Date Submitted to AP]2 <> "", "Green", IF([Fulfillment Receipt Received]3 <> "", "Yellow"))

Thank you so much!

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