I want the color to change to green if checkbox is checked and stay Red if it is not.

I have this formula but it is not working for me.

=IF(Done@row = 1, Status@row = "Green", Status@row = "Red")

I have 2 columns, one is a checkbox column, and one is a symbol column with Green, Yellow and Red options. I want the color to change to green if checkbox is checked and stay Red if it is not.

Can someone pls help me with this.

Find more posts tagged with

Accepted answers

Itai Perez

Hey @jurgen93

I think the formula you are looking for is this one :=IF(Done@row = "true", "Green", "Red")

It worked for me but let me know if I missed anything.

All comments

Itai Perez

Hey @jurgen93

I think the formula you are looking for is this one :=IF(Done@row = "true", "Green", "Red")

It worked for me but let me know if I missed anything.

jurgen93

Yes that worked. Thank you.

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.