Hi all,
It’s Holiday Season and our team of 10 has various and random schedules coming up.
In researching this, I did learn that Out of Office can be set for specific dates within the profile settings. Great! But, how to make those dates, and ones following it, unassignable dates? (profile only allows for ONE instance of dates)
Currently I have a group “OUT OF OFFICE” on the project board where the team can list their upcoming dates that they will be out of office. (currently primary tasks, NOT subitems; but it could be subitems)
I’ve scoured the community for suggestions as to how to make an automation CHECK the date that is listed in another task and change the status to “Assigned is OOO”. Sounds simple, but seems seems CHECKING is not a thing.
I’ve tried asking AI for a formula, not knowing or understanding how to write those:
“When person in “Assigned” column then check the Group OUT OF OFFICE for the LEAD person. IF the date in DUE column matches the date in Sub-Due Date then change the Sub-Status column to Assigned is OOO”
It’s a lot of variables, yep. Please let me know how I’ve overcomplicated this and a, hopefully, native solution.