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.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!