This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hello-When setting up an email automation, I want the Airtable record when opened to show in a specific view based on some conditional formatting, anyway when the recipient receives the email, when they open up the link provided which I don’t know. I...
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...
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...
