Changing day of the week based on data received from user

[Deano478]

Hi everyone, I have a test data set I'm messing around with and I have a problem that I could use some help with I feel I'm just thinking too much into it and it might be simple.

But Basically what I'm trying to do is any of the users who input there Index on a Friday, Saturday or Sunday this should actually display as Monday when a report is run every week.

I hope I worded that correctly as my English is not the best sometimes.

Submission_Date	Responders_Email	Index	Day_of_Week
10/09/2021	User1@Testing.com	5	Friday
10/09/2021	User2@Testing.com	4	Friday
10/09/2021	User3@Testing.com	5	Friday
10/09/2021	User4@Testing.com	5	Friday
10/09/2021	User5@Testing.com	3	Friday
18/09/2021	User6@Testing.com	3	Saturday
02/10/2021	User7@Testing.com	5	Saturday
09/10/2021	User8@Testing.com	5	Saturday
16/10/2021	User9@Testing.com	5	Saturday
16/10/2021	User10@Testing.com	3	Saturday
12/09/2021	User11@Testing.com	5	Sunday
26/09/2021	User12@Testing.com	2	Sunday
26/09/2021	User13@Testing.com	6	Sunday
17/10/2021	User14@Testing.com	4	Sunday
31/10/2021	User15@Testing.com	3	Sunday
13/09/2021	User16@Testing.com	2	Monday
20/09/2021	User17@Testing.com	5	Monday
27/09/2021	User18@Testing.com	6	Monday
04/10/2021	User19@Testing.com	1	Monday

[DataNath]

Hey @Deano478, do you just need the [Day_of_Week] changing here, or are you expecting the dates to be shifted 1/2/3 days as well accordingly?

[Deano478]

Hey @DataNath the User Indexes are given the day before (eg. an index sent on Monday is actually for Tuesday & and index given on Friday is actually for Monday) if that makes sense? 

[DataNath]

So you just want the display of the week day changing like so @Deano478?

Or do you also need days added to the [Submission_Date] field accordingly?

[Deano478]

@DataNath I was just messing around with workflow just now and yeah i would need to add days to the [Submission_Date] field accordingly. I appreciate the help with this matter hopefully I'm not frying your head with all the questions 

[DataNath · Accepted solution]

Ok no problem @Deano478, thanks for clearing that up! I've just added in an expression to handle the [Submission_Date] field as well - how does the following look?

Before:

After:

[Deano478]

@DataNath I really appreciate the helping hand this looks perfect i can see exactly what you did there and now it makes perfect sense to look at 

[Deano478]

@DataNath I didn't want to open a whole new topic and I apologise for disturbing you again I just have on follow up question for you relating to the same sample dataset. I just was wondering lets say for Example User1 above enters an index of 2 on Wednesday how could I possibly go about displaying that users index for the rest of the week i.e. Thursday and Friday? again i apologise for for the late follow up. 

Your help is much appreciated 

[DataNath]

Hey @Deano478, no problem! As in you want to create new rows for each User? Or you just want a full list of all the days from the day they entered the index through to Friday in the [Day_of_Week] field, rather than a single day?

[Deano478]

Hey @DataNath I just want a full list of all the days from the day they entered the index through to Friday in the [Day_of_Week] field, rather than a single day