Forum Discussion
Robert_Ennaco
Jun 23, 2020Copper Contributor
Complex If/Then assistance
Situation: As with many offices we are operating under a half on/half off rotation and I am trying to build a spreadsheet that can show who is teleworking and who is not on a given week based on the...
mtarler
Jun 23, 2020Silver Contributor
a sample of how your sheet is set up might help but if you have people listed then have a column for "Team" then in the corresponding weeks you can do a check that looks at the week and 'calculates' if they are teleworking. if you have date field you can use something like
=IF(XOR(ISEVEN(WEEKNUM(C$2)),$B3="RED"),"teleworking","in office")
where row 2 are your dates and then column B is your Team designator (e.g. "BLUE" or "RED").
=IF(XOR(ISEVEN(WEEKNUM(C$2)),$B3="RED"),"teleworking","in office")
where row 2 are your dates and then column B is your Team designator (e.g. "BLUE" or "RED").