for an ad-free Fetcheveryone experience!

SpreadEveryone: The Fetchland Excel wire

102 watchers

3M Jan 2024 12:30pm, 24 Jan 2024 23,162 posts	Quote Pin 3M * O365 !
GregP Jan 2024 12:52pm, 24 Jan 2024 150,368 posts	Quote Pin GregP Sounds a similar story to here. Alas the solutions don't really work.
run free Jan 2024 12:51am, 25 Jan 2024 5,327 posts	Quote Pin run free 3M - am also trying to connect a Msft Form to an O365 Excel workbook and have to use PowerForms. It has failed cos it wants me to download an app! I am ready to give up and return to Google Forms
run free Jan 2024 12:55am, 25 Jan 2024 5,328 posts	Quote Pin run free I guess I could use SharePoint Lists but want to learn Power Automate!
JamieKai chameleon Jan 2024 1:20am, 26 Jan 2024 18,262 posts	Quote Pin JamieKai chameleon Power Automate has been great for me. If I get the job I'm interviewing for on Monday (given it's been designed for me it's mine to lose) I'll be working hard on skilling up in both Power Automate and Power BI...
RichHL Jan 2024 2:58pm, 26 Jan 2024 22,965 posts	Quote Pin RichHL You can, if you are so minded, sing O365 to the tune of Vienna by Ultravox.
AndyS Jan 2024 3:16pm, 26 Jan 2024 2,588 posts	Quote Pin AndyS This means nothing to me. #Obligatory.
Big_G Apr 2024 10:54am, 19 Apr 2024 3,413 posts	Quote Pin Big_G Hi, my club's chairman has asked me to help out with something that I thought would be very simple, for a newsletter he sends regularly to members. He works in Numbers (he doesn't have Excel). I have Numbers and Excel. This is what he wants (this is from Excel, which he doesn't have). This is what I have been able to do in Numbers, which isn't quite the same. In summary, in excel it is possible to have the total displayed as a label for each stacked-bar, without showing it as a stack (260, 350, 625, 300, 325). I can't seem to find a way of doing similar in Numbers. I have Googled, but does anyone happen to know, as I do not usually use Numbers.
JamieKai chameleon May 2024 10:57am, 21 May 2024 18,695 posts	Quote Pin JamieKai chameleon Hi Excel nerds I've got a quick query that I know one answer to, but it's horribly unwieldy and I'm hoping there's a more elegant solution! I have a sheet to count up how work is allocated to team members, however not all members are trained on all areas of work. On our main Allocation page, I have a grid E9:K28 with rows for team members, and columns for types of work. I then have a management page with a similar sized grid D2:J21 where the manager can mark up with an X where people cannot undertake a task. I want to set up conditional formatting so that when there is an "X" in a cell in the management sheet, the corresponding cell in the allocation sheet is filled with grey. When I tried this last night I couldn't get it to work as a single conditional format, but I really don't want to resort to having 140 different conditions as that'd be messy! Any ideas?
JamieKai chameleon May 2024 5:23pm, 21 May 2024 18,696 posts	Quote Pin JamieKai chameleon JamieKai chameleon wrote:Utter waffle Solved. I'm an idiot. Just needed to drop the dollars. So simple when I took a fresh look, I'm such a dolt.