These spreadsheets are frustrating! I added a person earlier, but their days didn't calculate and the color didn't change. Who on this forum knows how to use these spreadsheets? We need someone who understands it to tweak it, so we don't experience anymore errors.Nras1923 said:Yes, please be careful! My row is missing info now which was there yesterday but isn't now.
It probably wasn't intentional though, so it's okay, as long as it's back in
I think I can fix that. There's a way to lock certain cells so that the formula is protected and no one can change IT. I can try that when I get home tonight.saria1 said:These spreadsheets are frustrating! I added a person earlier, but their days didn't calculate and the color didn't change. Who on this forum knows how to use these spreadsheets? We need someone who understands it to tweak it, so we don't experience anymore errors.
Still no news?muzmurad said:Sent mine in oct 14th, received on the 15th. No update here. Hang tight!
Very honest I must sayMaryL said:Sorry I was under the impression I could not add anything to the sheet as I am just on Galaxy5. Was not intending to touch anyones stats.
That would be great, thanks!CLYL said:I think I can fix that. There's a way to lock certain cells so that the formula is protected and no one can change IT. I can try that when I get home tonight.
But for sure I can get the formula to work.
I'm sure we're all going to have our turn making a mistake or 3 on that spreadsheetMaryL said:Sorry I was under the impression I could not add anything to the sheet as I am just on Galaxy5. Was not intending to touch anyones stats.
Thank you! I'm curious though, how do we change the color for the various phases of our application?CLYL said:ok. i fixed the formula. I think i checked everyone who's on the list as of now and the formula should be working. I'm not locking anything (decided against it) just in case something needs to be changed and I'm not around to do so.
It will change automatically once u enter the info...or at least it should...saria1 said:Thank you! I'm curious though, how do we change the color for the various phases of our application?
i'm not 100% sure if the formula is sophisticated enough to update colours automatically, but i can tell you how to do that manually.saria1 said:Thank you! I'm curious though, how do we change the color for the various phases of our application?
Ah ha, thank you, I changed the Applied in October's color to match her status. I don't know why that stumped me so muchCLYL said:i'm not 100% sure if the formula is sophisticated enough to update colours automatically, but i can tell you how to do that manually.
You are are row 42 now. So, if you place your pointer on '42', it highlights your entire row. if you click on the 'fill colour' (it's right around the middle of all the others) icon, you will see a whole range of colours and can select the colour to fill.
Nope, no news. Ecas doesn't work with mine either. I was told on Tuesday by Agent 1 that my file was in the inland queue, he said he would send a message out to the Mississauga office to switch it to the outland queue. Called back after panicking and was told by agent 2 that it wasn't the case. Still no word from them worries me.Zenga said:Still no news?
I am either thinking they returned my application or put it inland.
Oct 16th delivered through courier. 63 days of waiting. Should have called them this morning. No updates whatsoever and ecas doesn't work with my receipt number...