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!
Best Answer
-
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)
Answers
-
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)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!