Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I would like to schedule activities into specific hours of the day.
Thanks.
Here is my attempt
https://app.smartsheet.com/b/publish?EQBCT=19e517036f1f4efe9553c9e0c75b9824
Thank you very much Brett!, this is part of my problem, the next part is how to block certain day/time window when adding a new task, for example my first task is 01/01/2016 @ 8:00 a.m. and finishes 01/01/2016 10:00 a.m., if i need to add a second task for the same day, then i should be allowed to schedule from 10:00 a.m. to the end of the day, is there a way to do that.
Thank you again.
That seems possible.
In one coulumn, you would have to use a set of nested match/lookup functions to find the time and date with the key match value being the date in your row, This would allow you to see the time range you have available.
Then you would need to do some conditional formatting based on the time entered in your new row and use the value returned above to see if your value is valid based on your criteria.
Although it seems possible, it also seems like it would take many hours to days to get right. Good luck!
Thank you very much, i appreciate your help.
