Hi - I’m trying to create a doc to schedule tasks. I want to be able to pick a start date and time, then assign an hourly duration. I want to see how many tasks I can fit into a work day. I’m not sure how to get a task to roll into the next day if the hours exceed the work day hours. Hopefully that make sense.
Perhaps something akin to:
if(starttimestamp+duration>24,modifyrows(thisrow,starttimestamp,starttimestamp+days(1),else)
Thanks @Johg_Ananda! I’ll give that a try.