Conditional formula

Hello!

I'm trying to write a formula where the I account for back filled data and then data with a timestamped "Created" column date.

How can I combine the following two formulas?

The one for current data:

=IF([Backfilled Data]@row = 0, IF(MONTH([Date Submitted]@row) = 1, " (01) January", IF(MONTH([Date Submitted]@row) = 2, "(02) February", IF(MONTH([Date Submitted]@row) = 3, "(03) March", IF(MONTH([Date Submitted]@row) = 4, "(04) April", IF(MONTH([Date Submitted]@row) = 5, "(05) May", IF(MONTH([Date Submitted]@row) = 6, "(06) June", IF(MONTH([Date Submitted]@row) = 7, "(07) July", IF(MONTH([Date Submitted]@row) = 8, "(08) August", IF(MONTH([Date Submitted]@row) = 9, "(09) September", IF(MONTH([Date Submitted]@row) = 10, "(10) October", IF(MONTH([Date Submitted]@row) = 11, "(11) November", IF(MONTH([Date Submitted]@row) = 12, "(12) December"

The one for back filled data:

IF([Backfilled Data]@row = 1, IF(MONTH([Date 2]@row) = 1, " (01) January", IF(MONTH([Date 2]@row) = 2, "(02) February", IF(MONTH([Date 2]@row) = 3, "(03) March", IF(MONTH([Date 2]@row) = 4, "(04) April", IF(MONTH([Date 2]@row) = 5, "(05) May", IF(MONTH([Date 2]@row) = 6, "(06) June", IF(MONTH([Date 2]@row) = 7, "(07) July", IF(MONTH([Date 2]@row) = 8, "(08) August", IF(MONTH([Date 2]@row) = 9, "(09) September", IF(MONTH([Date 2]@row) = 10, "(10) October", IF(MONTH([Date 2]@row) = 11, "(11) November", IF(MONTH([Date 2]@row) = 12, "(12) December"

Thank you for your help!

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

You would drop the second into the third "value if false" portion of the first IF.

=IF([Backfilled Data]@row = 0, formula for if zero, formula for if not zero)

All comments

Paul Newcome

You would drop the second into the third "value if false" portion of the first IF.

=IF([Backfilled Data]@row = 0, formula for if zero, formula for if not zero)

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.