Use an IF statement to insert formula?

Is it possible to use an IF statement to insert the correct formula? Based on the hierarchy, I need one formula added for the parent rows but a different formula for the child rows. The individual formulas do work, but not in the IF statement. Wondering if there is a trick that I'm missing?

=IF(Hierarchy@row = 0, "=SUM(CHILDREN())", "=SUMIFS({LbrTrkCost}, {LbrTrkPrj}, Project@row, {LbrTblResource}, Resource@row, {LbrTblType}, "CapEx")")

Find more posts tagged with

Accepted answers

All comments

Adam Murphy

=IF(Hierarchy@row = 0, SUM(CHILDREN()), SUMIFS({LbrTrkCost}, {LbrTrkPrj}, Project@row, {LbrTblResource}, Resource@row, {LbrTblType}, "CapEx"))

auream00

I should have prefaced that I have tried this with and without quotes. Quotes give the "Unparseable" error; without quotes, gives the "Invalid Operation" error.

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.