If Formula

Need help saying add if this formula = 0 then it needs to =[Paid ($)]@row

=SUMIFS({Material Requisition - Inv Amount}, {Material Requisition - Anticipated Year}, Year@row, {Material Requisition - Anticipated Month}, [Month - Count]@row, {Material Requisition - Location}, Data@row)

Find more posts tagged with

Accepted answers

All comments

BullandKhmer

And if it doesnt =0?

Samuel Dowdy Jr.

If it does = 0

Kelly Moore

Hey @Samuel Dowdy Jr.

I think you are asking for this?

=IF(SUMIFS({Material Requisition - Inv Amount}, {Material Requisition - Anticipated Year}, Year@row, {Material Requisition - Anticipated Month}, [Month - Count]@row, {Material Requisition - Location}, Data@row)=0, [Paid ($)]@row, SUMIFS({Material Requisition - Inv Amount}, {Material Requisition - Anticipated Year}, Year@row, {Material Requisition - Anticipated Month}, [Month - Count]@row, {Material Requisition - Location}, Data@row))

Does this work for you?

Kelly

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.