If it's blank, Red Symbol. If it's not blank, Green symbol.

Nicole Endsley

I'm trying to get this formula to work correctly.

=IF(NOT(ISBLANK([Link to ARP plan]@row)), "Yes", IF(ISBLANK([Link to ARP plan]@row)), "No"))

It's not working. Any thoughts?

Find more posts tagged with

Formulas

Accepted answers

Sameer Karkhanis

Make sure your column type where you are using the formula is defined as Symbol column type and with the R,G,Y statuses. Use the formula below,

=IF(ISBLANK([Link to ARP plan]@row), "red", "green")

All comments

Sameer Karkhanis

Make sure your column type where you are using the formula is defined as Symbol column type and with the R,G,Y statuses. Use the formula below,

=IF(ISBLANK([Link to ARP plan]@row), "red", "green")

Nicole Endsley

Thanks @Sameer Karkhanis That worked!

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.