Hi everyone,
I currently have a base where there is a column for DIMENSIONS in the form of manual entry formated as such: 12" x 10" x 8"
I would like to SPLIT the numerical values into 3 different columns (column 1 = 12, column 2 = 10, column 3 =
F...
Hi folks,
I am fairly new to the formula game and I’m working on a formula where I have 3 columns with dates
{LOI Target}, {ETA to AMZ}, {Content Delivery Date}
and i’ll need to
calculate the latest date out of the three of theseAdd 7 days to the lat...
Hi folks,
I cannot figure out why this formula is not outputting what I need. My current formula for the column is this:
IF({ETA (AMZ) Date}="",“Need ETA (AMZ) Date”,DATEADD({ETA (AMZ) Date}, (7 - (WEEKDAY({ETA (AMZ) Date}) - 2)),‘days’))
If there is...
Ah! Thank you!
One more question for you:
VALUE(
REGEX_REPLACE(
Name,
“(\d*\.\d)(\D*)(\d*\.\d)(\D*)(\d*\.\d)”,
“$#”
)
)
In the “Name” section, is this where I would put the column name I am pulling from? I’m guessing no based on this formula I attemp...
this seems to have almost solved my problem:
IF(
{ETA (AMZ) Date},
DATETIME_FORMAT(
DATEADD({ETA (AMZ) Date},(7-(WEEKDAY({ETA (AMZ) Date})-2)) , “days”),
“MM/DD/YYYY”
),
“Need ETA (AMZ) Date”
)
I’ll do a bit of tweaking for my specific errors but you...
