cant get IF statement to change value of another cell

Andrew1983

I am trying to use an IF statement to change the value of "Ball in Court" based on the "PM question" cell:

FYI - both "Ball in court" and "pm question" are dropdowns

=IF([PM Question]@row = "02 - Changes Needed", [Ball in Court]@row = "01 - ENGINEERING", "")

When I set "PM question" to "01 - Submitted" the formula doesn't error, however when I set it to "02 - Change needed" I am getting an error as shown below. Help!

Find more posts tagged with

Formulas

Accepted answers

Leibel S

@Andrew1983

Formulas do not act as functions that can assign values to other cells.

To set the value of [Ball in Court] you would need to have a formula in the [Ball in Court] Column.

For example the below can be placed in the [Ball in Court] and it would change to 01 - ENGINEERING when you update the PM Question to 02 - Changes Needed

=IF([PM Question]@row = "02 - Changes Needed", "01 - ENGINEERING", "")

All comments

Leibel S

@Andrew1983

Formulas do not act as functions that can assign values to other cells.

To set the value of [Ball in Court] you would need to have a formula in the [Ball in Court] Column.

For example the below can be placed in the [Ball in Court] and it would change to 01 - ENGINEERING when you update the PM Question to 02 - Changes Needed

=IF([PM Question]@row = "02 - Changes Needed", "01 - ENGINEERING", "")

Andrew1983

The challenge I am trying to solve is having that "ball in court" column show who "owns" that line item right now. Maybe I am going about this the wrong way. I was having people manually change that column (i.e. the engineer finishes their work, they change it PM so it notifies the PM) but maybe changing the "work status" to finished would trigger this...

thank you for the information though, that confirms what I was suspecting in the back of my mind.

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.