if and formula not working

Hi,

looking for help on this formula

I would like for two conditions to be met for the total contract hours value to count towards the sum of the column.

so if the PIP type is equal to "CE PIP AC" and the status ball is green then the hours for that row should count in my sum.

I hope that makes sense.

=IF(AND([PIP TYPE]@row = "CE PIP AC"), [STATUS]@row = "GREEN"), =SUM(TOTAL CONTRACT HOURS:TOTAL CONTRACT HOURS)

Any help/guidance is appreciated. Thank you in advance.

Find more posts tagged with

Accepted answers

All comments

=Chris Palmer

Hello @LisaPetersonBW

Does this formula work for you?

=IF(AND([PIP TYPE]@row = "CE PIP AC"), [STATUS]@row = "GREEN"), SUM([TOTAL CONTRACT HOURS]:[TOTAL CONTRACT HOURS)]

This formula will populate "GREEN" if "CE PIP AC" is found, otherwise it will SUM the Total Contract Hours Column.

LisaPetersonBW

Hi Chris

Thank you for your reply, however, the formula is not working. it's not a green status ball it is a drop down Yes, No.

Sorry for the confusion.

Would I replace the "green" with "yes".

Also, I am hoping to have the cell to reflect the total contracts hours when the values in the status column are "Yes" and the "CE PIP AC".

I appreciate your help

Lisa

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.