I am building a schedule template for security guards. The shifts are alway friday, sat, sun from 7:00 to 17:00. I run an automation that every week it creates the shift templates so the supervisor can just plug in who will take each shifts.
The thing is.... automation doesnt allow me to add a time to a date. What?! i KNOW right!! 😱
So i created a column called start time and end time.....but catch this.... DATE AND TIME WONT ADD in datetimeadd or datediff or +....
Now i am on my fourth coffee and foaming at the mouth screaming at chat gpt cause he can't figure it out either.
Are there anyone out there whom as mastered this yet?
Smartsuite people, can we make this a thing in the futur? 🫶