Hi, I am aiming to use a Monday.com board to track staff holiday and sick days - See screen shot below.
I have made a group for a month, added 31 columns with status boxes for ‘Holiday, sickness, weekend’ etc and I would like to be able to have a ‘Holiday total’ column at the beginning. It would need to be able to count how many times there was a ‘Holiday’ status in that month, but I can’t figure out the best way to do it.
Ideally the ‘Count’ would carry over from month to month, as I will have a new ‘group’ for each Month.
Any advice would be great, and I hope that makes sense!
To calculate the number of times the status label “Holiday” appears in an item, you would need to create a formula that checks for the status in each column, gives that column a “1” if it appears, and then add the results together:
However, this is is not something you could have “carry-over” to a new month for a new group as each item is unique and will only take the item it is a part of into account when calculating.
With that in mind, can you elaborate on why you need this information to carry-over each month so I can better understand what possible solutions we have for you?
In the meantime, you may find some helpful information in one of our formula support articles:
