If Formula Help: =IF X symbol and X symbol are X, display X in this column

I'd like to select text in a column based on symbol indicators in a column.

For example if they are highly impacted, with a "!" symbol and they are not influential with a (down arrow) symbol, i want to indicate that i should reach out to them weekly. See pic. Please help with how I can set up the formula to do this automatically.

Find more posts tagged with

Formulas

IF(

Accepted answers

Larry

=IF(AND([Impact on Stakeholder]@row = "High", [Stakeholder Influence]@row = "Low"), "Weekly")

You can continue the IF(AND( logic to handle all combinations

All comments

Larry

=IF(AND([Impact on Stakeholder]@row = "High", [Stakeholder Influence]@row = "Low"), "Weekly")

You can continue the IF(AND( logic to handle all combinations

Jharris11

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