Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-869512%22%20slang%3D%22en-US%22%3EFormulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-869512%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%20I'm%20trying%20to%20find%20a%20way%20to%20take%20the%20daily%20presence%20of%20my%20workers%20in%20a%20monthly%20calendar%20sheet%20and%20recognize%20and%20count%20automatically%20the%20days%20that%20the%20worker%20do%20from%20a%20range%20of%202%20to%2010%20projects%2C%20base%20on%20the%20color%20of%20its%20project%20and%20after%20the%20calculation%20been%20done%20put%20the%20sum%20in%20a%20pecific%20cell.%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F133051i417B4ED21768EC57%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22IMG_20190923_005734.jpg%22%20title%3D%22IMG_20190923_005734.jpg%22%20%2F%3E%3C%2FSPAN%3E%26nbsp%3B%20%26nbsp%3BAs%20you%20see%20%2C%20i%20want%20to%20colorized%20the%20day%20that%20someone%20works%20in%20the%20orange%20project%20and%20automatically%20make%20the%20sum%20of%20all%20the%20days%20that%20worked%20there%20and%20put%20the%20sum%20at%20the%20cell%20of%20each%20worker%20%2C%20to%20the%20orange%20or%20blue%20or%20whatever%20project..%3C%2FP%3E%3CP%3ECan%20anybody%20help%20me%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-869512%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-871808%22%20slang%3D%22en-US%22%3ERe%3A%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-871808%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F413305%22%20target%3D%22_blank%22%3E%40Charalampos_K%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20will%20need%20to%20write%20a%20function%20that%20will%20count%20the%20colours%20for%20you.%20I%20have%20attached%20a%20sample%20spreadsheet%20with%20a%20user%20function%20%26nbsp%3Bthat%20will%20work%20for%20you.%20I%20have%20also%20put%20a%20link%20in%20the%20sheet%20to%20the%20web%20page%20that%20details%20how%20this%20is%20done.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERich99%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Charalampos_K
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.

 

Rich99

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies