I'm using the Absence-Vacation Schedule Template provided by microsoft to keep track of sick days, personal days, etc. Now I believe (I could be wrong and if I am please correct me) that as it is, I can't set up a calculated field that sums end time - start time and looks at the absence type (it's a lookup field) and get it to propagate a message. If I'm not mistaken, lookup fields do not work with calculated values.
So what I'm doing is, creating another absencetype field in the same list so that I can use it on the calculated field. My issue is that I don't quite get the sintaxis correctly. I'm gonna write here the formula I'm using hopefully someone could tell me why it's not working and how to go about it.
I'm interested in people going in and putting down their days off but for example, the max # of personal days is 3 so if they try to request a 4th I want a message to say "You've Maxed out your personal days". And this is the formula I used:
=IF([End Time]-[Start Time]=3, AND([AbsenceType]=Personal
Days, You have maxed out your personal days. ))
Start Free Trial
