General Caster IF/THEN statement with Date to Timeline formula

[KayBo (Kayley Boan)]

I am looking to change a timeline by a set number of days when a date changes, but only under certain conditions (depending on status). Below is a picture of my board.

I am using general caster to cast the formula to the timeline column. When the send date changes, I want the timeline column to change by a certain number of days if the email is “Initial”. But I want it to change by a different number of days if it is “Reminder”.

See the formula I am using below:

IF({Email’s Email Sequence}=“Initial”,(CONCATENATE(TEXT(DATEVALUE({Email’s Send Date}) - 41, “YYYY-MM-DD”), “+”, TEXT(DATEVALUE({Email’s Send Date}) - 27, “YYYY-MM-DD”)),IF({Email’s Email Sequence}=“Reminder”,(CONCATENATE(TEXT(DATEVALUE({Email’s Send Date}) - 67, “YYYY-MM-DD”), “+”, TEXT(DATEVALUE({Email’s Send Date}) - 33, “YYYY-MM-DD”)),“DO-NOTHING”

The formula only works if I do not have the IF statements. I cannot get anything to work if I put that in but general caster says that it “ran” (no error messages).

Any ideas?

[hellotimi (David Kalu (Formula PRO - Advanced Automations for native monday formula columns, Mirror Columns & Subitems!))]

@KayBo
I tried fixing the issue in your formula in General Caster but I was unable to get it to work, but with this other app which is a great and far cheaper alternative (1000 ops/month on the free tier), this works:

IF(RIGHT({Email's Email Sequeunce}, LEN({Email's Email Sequeunce}) - FIND(":", {Email's Email Sequeunce}))=="Initial", CONCATENATE(TEXT(DATEVALUE({Email's Send Date}) - 41, "YYYY-MM-DD"), "+", TEXT(DATEVALUE({Email's Send Date}) - 27, "YYYY-MM-DD")), IF(RIGHT({Email's Email Sequeunce}, LEN({Email's Email Sequeunce}) - FIND(":", {Email's Email Sequeunce}))=="Reminder", CONCATENATE(TEXT(DATEVALUE({Email's Send Date}) - 67, "YYYY-MM-DD"), "+", TEXT(DATEVALUE({Email's Send Date}) - 33, "YYYY-MM-DD")), "DO-NOTHING"))

This extra bit is required to extract the status column label from the status column, this is because the status column is handled as <index>:<label> by the app.

RIGHT({Email's Email Sequeunce}, LEN({Email's Email Sequeunce}) - FIND(":", {Email's Email Sequeunce}))=="Initial"

But everything else remains the same.

Let me know if it works.

Disclaimer: I’m one of the developers of the app.