I am running a holiday calendar on smartsheet and looking to increase its functionality.
I'm currently trying to write a formula using a countifs were if employee A puts a holiday request through it checks all of employee A previous entries to see if it clashes with a previous entry.
the formula i'm using isn't right and any suggestions on where to go with it would be great as my tiny mind is going to explode.
The columns i'm checking are start date, end date and employee name.
=COUNTIFS([EMPLOYEE NAME]:[EMPLOYEE NAME], [EMPLOYEE NAME]@row, [START DATE]:[START DATE], >=[START DATE]@row, [START DATE]:[START DATE], <=[END DATE]@row)
Help Article Resources
Check out the Formula Handbook template!