Conditional formula

Brooks
Brooks ✭✭✭✭
edited 08/07/23 in Formulas and Functions

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!

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!