Home

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
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
Highlighted

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