Hi everyone,
Iโm trying to make a schedule view of the current jobs of the week and who is assigned to where on what day.
I currently use for example (Monday):
=IF(WEEKDAY([Clean Date])=2, [_Cleaners - Clean] , IF(WEEKDAY([Repair Date])=2, [_Repairers - Repair], IF(WEEKDAY([Paint Date])=2, [_Painters - Paint]," ")))
but how would I write it if I only wanted it to show this current week and not every other week as well overlapping?
I will attach a photo of what it is currently showing.
Hi @Mark_Tuckey,
I believe based on your description, you are currently getting all dates on a day where weekday matches that date.
if it is so,I believe, you may wish to try something like below
=IF(AND(WEEKNUM([Clean Date])=WEEKNUM(Today()),WEEKDAY([Clean Date])=2), [_Cleaners - Clean] , IF(AND(WEEKNUM([Repair Date])=WEEKNUM(Today()),WEEKDAY([Repair Date])=2), [_Repairers - Repair], IF(AND(WEEKNUM([Paint Date])=WEEKNUM(Today()),WEEKDAY([Paint Date])=2), [_Painters - Paint]," ")))
This expression assumes week starts on a Sunday.
You should add the year as wellโฆ IFS( AND( WEEKNUM([Clean Date])=WEEKNUM(Today()), YEAR([Clean Date])=YEAR(Today()), WEEKDAY([Clean Date])=2), [_Cleaners - Clean], โฆ
Hi @Aleksi_Alkio, Your insight is valuable as always. Adding the year, makes the expression perfect to work in all conditions.
@Aleksi_Alkio @Suvrutt_Gurjar thanks guys that worked perfectly.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |