Hello! Is these a way to reverse this? To show 2023/Q1 instead of Q1/2023. IF({Your Date Field}, “Q” & DATETIME_FORMAT({Your Date Field},‘Q/YYYY’) )

Hello- Trying add a field that can add days to my formula, any thoughts? IF({DC Arrival Date}=BLANK(), BLANK(), IF(OR({Production Type} = ‘Domestic’,{Production Type} = ‘Puzzles’), DATETIME_FORMAT(DATEADD({DC Arrival Date},-56,‘Days’),‘MM/DD/YYYY’), ...

Hello- Does anyone know how to remove the : in front of asset type when the Item Descr and the Multi game is blank? I keep getting this : EMAIL - ANNOUNCEMENT: COMICS PRO - FEB: 2023 Email is the Asset Type IF( {ASSET TYPE}, CONCATENATE({ITEM DESCRIP...

Hello- Does anyone have a an automations solution with this one? Trying to add in a Adobe URL and have it automatically convert to a PDF in another attachment field using an automation. I did try it out and this was the message I got: JavaScript is r...

Hello- Any help with if CAMPAIGN THEME is blank, the “-” will not show in the formula? IF( {CAMPAIGN NAME}, CONCATENATE( IF( {CAMPAIGN BRAND}, {CAMPAIGN BRAND} & IF(OR({CAMPAIGN NAME}, {CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}), " - ", “”) ), I...