Occasional Visitor

Hello everyone, I'm trying to find a way to take the daily presence of my workers in a monthly calendar sheet and recognize and count automatically the days that the worker do from a range of 2 to 10 projects, base on the color of its project and after the calculation been done put the sum in a pecific cell.IMG_20190923_005734.jpg   As you see , i want to colorized the day that someone works in the orange project and automatically make the sum of all the days that worked there and put the sum at the cell of each worker , to the orange or blue or whatever project..

Can anybody help me?


Thank you !!!

1 Reply

Hi, @Charalampos_K 


You will need to write a function that will count the colours for you. I have attached a sample spreadsheet with a user function  that will work for you. I have also put a link in the sheet to the web page that details how this is done.



Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies