Combine two IF formulas

Shannon Heward

Can someone kindly help me combine these two formulas? It's too complicated for the AI formula generator. :)

=IF(MONTH([Global Trade Compliance Approval Date]@row ) = 1, "January", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 2, "February", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 3, "March", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 4, "April", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 5, "May", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 6, "June", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 7, "July", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 8, "August", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 9, "September", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 10, "October", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 11, "November", IF(MONTH([Global Trade Compliance Approval Date]@row ) = 12, "December")))))))))))) + " " + DAY([Global Trade Compliance Approval Date]@row ) + "," + " " + YEAR([Global Trade Compliance Approval Date]@row )

=IF(MONTH([Global Trade Operations Approval Date]@row ) = 1, "January", IF(MONTH([Global Trade Operations Approval Date]@row ) = 2, "February", IF(MONTH([Global Trade Operations Approval Date]@row ) = 3, "March", IF(MONTH([Global Trade Operations Approval Date]@row ) = 4, "April", IF(MONTH([Global Trade Operations Approval Date]@row ) = 5, "May", IF(MONTH([Global Trade Operations Approval Date]@row ) = 6, "June", IF(MONTH([Global Trade Operations Approval Date]@row ) = 7, "July", IF(MONTH([Global Trade Operations Approval Date]@row ) = 8, "August", IF(MONTH([Global Trade Operations Approval Date]@row ) = 9, "September", IF(MONTH([Global Trade Operations Approval Date]@row ) = 10, "October", IF(MONTH([Global Trade Operations Approval Date]@row ) = 11, "November", IF(MONTH([Global Trade Operations Approval Date]@row ) = 12, "December")))))))))))) + " " + DAY([Global Trade Operations Approval Date]@row ) + "," + " " + YEAR([Global Trade Operations Approval Date]@row )

Thank you so much!!

jmyzk_cloudsmart_jp

Hi @Shannon Heward

https://app.smartsheet.com/b/publish?EQBCT=ab9bcd90b43b4e5e83d234ff6089ed9a

=IF(
AND(ISDATE([Compliance Approval]@row ), ISDATE([Operations Approval]@row )),

"Compliance: " +
IF(MONTH([Compliance Approval]@row ) = 1, "January",
IF(MONTH([Compliance Approval]@row ) = 2, "February",
IF(MONTH([Compliance Approval]@row ) = 3, "March",
IF(MONTH([Compliance Approval]@row ) = 4, "April",
IF(MONTH([Compliance Approval]@row ) = 5, "May",
IF(MONTH([Compliance Approval]@row ) = 6, "June",
IF(MONTH([Compliance Approval]@row ) = 7, "July",
IF(MONTH([Compliance Approval]@row ) = 8, "August",
IF(MONTH([Compliance Approval]@row ) = 9, "September",
IF(MONTH([Compliance Approval]@row ) = 10, "October",
IF(MONTH([Compliance Approval]@row ) = 11, "November",
"December"))))))))))) +
" " + DAY([Compliance Approval]@row ) + ", " +
YEAR([Compliance Approval]@row ) +

" | Operations: " +
IF(MONTH([Operations Approval]@row ) = 1, "January",
IF(MONTH([Operations Approval]@row ) = 2, "February",
IF(MONTH([Operations Approval]@row ) = 3, "March",
IF(MONTH([Operations Approval]@row ) = 4, "April",
IF(MONTH([Operations Approval]@row ) = 5, "May",
IF(MONTH([Operations Approval]@row ) = 6, "June",
IF(MONTH([Operations Approval]@row ) = 7, "July",
IF(MONTH([Operations Approval]@row ) = 8, "August",
IF(MONTH([Operations Approval]@row ) = 9, "September",
IF(MONTH([Operations Approval]@row ) = 10, "October",
IF(MONTH([Operations Approval]@row ) = 11, "November",
"December"))))))))))) +
" " + DAY([Operations Approval]@row ) + ", " +
YEAR([Operations Approval]@row )
)

jmyzk_cloudsmart_jp

Hi @Shannon Heward

https://app.smartsheet.com/b/publish?EQBCT=ab9bcd90b43b4e5e83d234ff6089ed9a

=IF(
AND(ISDATE([Compliance Approval]@row ), ISDATE([Operations Approval]@row )),

"Compliance: " +
IF(MONTH([Compliance Approval]@row ) = 1, "January",
IF(MONTH([Compliance Approval]@row ) = 2, "February",
IF(MONTH([Compliance Approval]@row ) = 3, "March",
IF(MONTH([Compliance Approval]@row ) = 4, "April",
IF(MONTH([Compliance Approval]@row ) = 5, "May",
IF(MONTH([Compliance Approval]@row ) = 6, "June",
IF(MONTH([Compliance Approval]@row ) = 7, "July",
IF(MONTH([Compliance Approval]@row ) = 8, "August",
IF(MONTH([Compliance Approval]@row ) = 9, "September",
IF(MONTH([Compliance Approval]@row ) = 10, "October",
IF(MONTH([Compliance Approval]@row ) = 11, "November",
"December"))))))))))) +
" " + DAY([Compliance Approval]@row ) + ", " +
YEAR([Compliance Approval]@row ) +

" | Operations: " +
IF(MONTH([Operations Approval]@row ) = 1, "January",
IF(MONTH([Operations Approval]@row ) = 2, "February",
IF(MONTH([Operations Approval]@row ) = 3, "March",
IF(MONTH([Operations Approval]@row ) = 4, "April",
IF(MONTH([Operations Approval]@row ) = 5, "May",
IF(MONTH([Operations Approval]@row ) = 6, "June",
IF(MONTH([Operations Approval]@row ) = 7, "July",
IF(MONTH([Operations Approval]@row ) = 8, "August",
IF(MONTH([Operations Approval]@row ) = 9, "September",
IF(MONTH([Operations Approval]@row ) = 10, "October",
IF(MONTH([Operations Approval]@row ) = 11, "November",
"December"))))))))))) +
" " + DAY([Operations Approval]@row ) + ", " +
YEAR([Operations Approval]@row )
)

Shannon Heward

Thank you! I appreciate the help!

jmyzk_cloudsmart_jp

Happy to help!😁

Paul Newcome

Just a note: I like to get rid of parenthesis every chance I get. They are so easy to misplace or forget, not to mention a lot of IFs will eventually start making an impact on sheet performance at a larger scale. The two methods I use (depending on the case) when I want to output the month text for a date would be:

A basic INDEX function with a cross sheet reference to another sheet that has the months listed in order starting in row 1

=IFERROR(INDEX({Month Text Column}, MONTH([Date Column]@row)), "")

For much larger scale when cross sheet references are nearing their limits or for just plain old super large sheets, I will use a MID function like so:

=MID("01January02February03March04April05May06June07July08August09September10October11November12December13", FIND(RIGHT("0" + MONTH([Date Column]@row), 2), "01January02February03March04April05May06June07July08August09September10October11November12December13") + 2, FIND(RIGHT("0" + (MONTH([Date Column]@row) + 1), "01January02February03March04April05May06June07July08August09September10October11November12December13") - (FIND(RIGHT("0" + MONTH([Date Column]@row ), 2), "01January02February03March04April05May06June07July08August09September10October11November12December13") + 2))

I do admit that the nested IF is easier to read when outputting the full text for each month, but this saves a few keystrokes and a bit of processing power if your sheet starts to lag a bit.

And the MID formula for just outputting 3 characters for the month text is much more simple:

=MID("12JanFebMarAprMayJunJulAugSepOctNovDec", MONTH([Date Column]@row) * 3, 3)