Formula Help

Hi All,

I have an approval column which which clicked on, would like to have a tick/cross at the beginning of the row.. Essentially, if CSG Approval (Column 1) is approved, a green tick (as yes in column properties) should appear in Project Approval (column 2) vice versa, if rejected, should have a red cross (as no in column properties) in project approval.

The formula I have is not working and I've tried to manipulate as much as possible. Can anyone please help :)

=IF([CSG Approval]@row = "Approved - Strategic", "Approved - Departmental", "Yes"), IF([CSG Approval]@row = "Reject", "No"))

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Try something like this...

=IF(CONTAINS("Approved", [CSG Approval]@row), "Yes", "No")

All comments

Paul Newcome

Try something like this...

=IF(CONTAINS("Approved", [CSG Approval]@row), "Yes", "No")

Danielle Bastos

@Paul Newcome Thank you!

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.