Schedule for team

[kurdo]

Good morning y'all,
I would like to create a schedule for my team, my excel has TaskName and DateName, and i would like to create a table to visualize for exemple this weeks what's are the task that we has to do, and also there's a lot of tasks that has to be done every monday...(Recurrent Tasks). I've tried to load my Excel and create a mastercalendar but couldn't have any solution.

Do you guys have any idea to create a schedule for the whole year from an excel and visualizing a table with all the informations

i'm new on QS and btw we don't have acces to QMS or anything
best regards,

[Daniel_Pilla]

Hi @kurdo ,

More information would be helpful here, for example sample data and an example of how you'd like to visualize it.

Cheers,

[kurdo]

Hello @Daniel i would like to have a table like this in my sheet on QS, the problem here is if i load this on QS, the heads will be load as a string(Exemple : 01/01/2024 it will be 42454) not as a Date, i tried many things and didn't work. here on the screen A,B,C,D first and second row are merged btw
Thank you

[vinieme12 · Accepted solution]

42454 is the numeric representation of the date, you just need to reformat it using Date() function

Can you post some sample data in excel?