I am currently setting up the workflow for employee time off requests (via forms) and I have trouble with the formulas
I would like a formula where
1- That would count the workdays off in the ‘‘vacation days’’ column if status is ‘‘vacation’’
2- That would count the workdays off in the ‘‘sick day’’ column if status is ‘‘sick day’’ or ‘‘acident’’
3- That would count the workdays off in the ‘‘other leaves’’ column for the remaining status
4- I would also like a formula that counts the days off with the timeline option or an automated population of the timeline with choosing two dates (for visibility on the shared calendar)
Lastly I would like one last formulas that deducts the vacations rights formula from the the vacations taken already and display the remaining days left.
THANK YOU !