Skip to main content

Hi! I'm trying to set up a formula for a "Production Slack Reminder" that would be based on the "Send Date."

 

If the "Send Date" falls on a Tuesday, Wednesday, Thursday, or Friday, the "Production Slack Reminder" should happen the day before the "Send Date"

If the "Send Date" falls on a Monday, Saturday, or Sunday, the "Production Slack Reminder" should happen the Friday before that weekend

Try this:

SWITCH( DATETIME_FORMAT( {Send Date}, 'ddd' ), 'Sat', DATEADD({Send Date}, -1, 'days'), 'Sun', DATEADD({Send Date}, -2, 'days'), 'Mon', DATEADD({Send Date}, -3, 'days'), 'Tue', DATEADD({Send Date}, -1, 'days'), 'Wed', DATEADD({Send Date}, -1, 'days'), 'Thu', DATEADD({Send Date}, -1, 'days'), 'Fri', DATEADD({Send Date}, -1, 'days') )