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