# Conditional formula

Options
✭✭✭✭
edited 08/07/23

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"

Tags:

• ✭✭✭✭✭✭
Options

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)

• ✭✭✭✭✭✭