Change Date column if new row is added after hours
Hello - We have a simple ticket system and if a ticket request from a form comes in after 4:00pm, we don't start the ticket until the next day.
Form Entry happens at 2:30pm on 07/27/23. Start Date column should read 07/27/23.
Form Entry happens at 4:30pm on 07/27/23. Start Date column should read 07/28/23.
So we want the Start Date to reflect the next day if the ticket comes in after 4:00pm. Is that possible? Through Automations, Bridge or anything else? I've been scratching my head trying to think of a workaround.
Thank you in advance,
"Strive for Progress, not perfection."
Help Article Resources
Check out the Formula Handbook template!