Background Smart Formulas can be used to select different earnings rates on public holidays. In order to do so, they must first be configured in UpSheets (even though Xero has public holidays configured, they are not available publicly). Basic Setup To use public holidays, it must first be enabled: Smart Formulas> Smart Formula Settings> Holidays https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/MXaz7Onx3j/enable%20smart%20formulas.png (enable smart formulas) Then click Setup Holidays and then Add each holiday to the default calendar https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/jgcT0Zk7dv/add%20holiday.png (add holiday) https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/zro1FGCMN5/calendar%20setup.png (calendar setup) Once complete click Back to Settings to exit Default Calendar As standard, a single Default Calendar is available and automatically assigned to all employees. https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/11KhSBg2hM/default%20calendar.png (default calendar) Using Additional Calendars If you require more calendars, simply click Add Calendar, give it a name and click Save. You can then add holidays in the same way as usual. https://malcolm-en-gb.s3.eu-west-1.amazonaws.com/instances/j0x2GOjMS3/resources/ah4ZgsVVVe/add%20calendar.png (add calendar) NOTE: You must add all required dates for each calendar. When multiple calendars are defined, you can optionally select a calendar for each employee. If some employees do not need a calendar, simply set up a calendar with no holidays and assign it as required.