Scott_Gardner1 - profile

Scott_Gardner1 · Jan 26, 2023

Hello-I am trying to roll up 10 date fields that are all deadline dates to a long text field in a bullet format.Ideally I would want the field name to be visible as well as the date like this (Field name/Date):- Designer due date: 1-2-23- Submittal d...

Scott_Gardner1 · Nov 23, 2022

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’) )

Scott_Gardner1 · Nov 22, 2022

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’), ...

Scott_Gardner1 · Nov 03, 2022

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...

Scott_Gardner1 · Oct 26, 2022

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...

Scott_Gardner1 · Nov 23, 2022

Perfect, thank you Ben!!

Scott_Gardner1 · Nov 22, 2022

Thank you very much! I need to add some clarity, I am trying to create another field that is a number field, let’s call it “Add Lead Time”. When a number, let’s say 7 is added to this field, it will auto add 7 days to the formula which is a date fiel...

Scott_Gardner1 · Sep 22, 2022

Thanks Jeremy- The Key Fields are: MARKETING CAMPAIGN TITLE If there is a MARKETING CAMPAIGN TITLE then it overrules the ITEM DESCRIPTION and it doesn’t show. If an ASSET TYPE AND ASSET TASK are selected, I want it to show always. And if there isn’t ...

Scott_Gardner1 · Sep 22, 2022

Jeremy_Oglesby: IF( {CAMPAIGN NAME}, CONCATENATE( IF( {CAMPAIGN BRAND}, {CAMPAIGN BRAND} & IF(OR({CAMPAIGN NAME}, {CAMPAIGN TYPE}, {CAMPAIGN THEME}, {EVENT NAME}), " - ", "") ), IF( {CAMPAIGN NAME}, ...

Scott_Gardner1 · Sep 19, 2022

Where do I insert, if Marketing Campaigns is blank, Then in place of {Marketing Campaigns}, ‘Marketing Request’ is auto filled: MARKETING CAMPAIGNS - OFFICE: WALL DECORATION (IF FILLED IN) If not: MARKETING REQUEST - OFFICE: WALL DECORATION (IF FILLE...

User Statistics

User Activity

Multiple date roll-up to long text bullet format

Reverse Quarter and Date Formula

Add a number to a date formula help?

Formula question IF statement removing characters

Convert adobe url to attachment with automations

Re: Reverse Quarter and Date Formula

Re: Add a number to a date formula help?

Re: Formula question concatenate

Re: Formula question concatenate

Re: Formula - remove characters