I have a spreadsheet that is a calendar for consultants. I have the primary column using the consultants name as the Grandparent, the Month as the Parent and the weeks of the month as the children.
I have a summary at the top of my project plan that has, as a part of it, phase 1, phase 2 and phase 3 go-livedates. I would like those dates to update automatically when the start date of the go-live changes. I've tried a simple =cellname1 but I get a #numberexpected error. Do I need to convert it
Rightnow the milestones are represented by a diamond in between two days.
This is VERY confusing. Does it mean that the deadline is by the end of the one day or by the start of the other?
We would very much like to have the milestone centered on the specific day on which the deadline actually
I have a formula that is counting the different status of projects. This is what I have so far but the counts are not accurate. This might be because there are children however the total count is correct.
Any ideas to what is missing?
="Status Count: " + COUNT(Status:Status) + "
What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (%
Does anyone know what future integrations there are going to be for Microsoft 365?
I would like to be able to have a master smart sheet that has all data on but also be able to assign individual employees their own tasks without them having to scroll through the whole of the master smart sheet. Can employees have their own smart sheet and if so when they update their smart sheet