Replies

Hi Joe. I fully agree.

re:

Is the folder accessed by guests or users? BOTH
Are users members of the Team? SOME
Do you have a SharePoint admin? YES, BUT NEITHER OF US IS STRONG.

Thanks NetDef. That’s pretty much what I know about SP security so far. It’s not working for everyone and I’m getting close to the bottom of it. I just wish there was a way to do the Word based restrict editing on a bunch of files at once!

[WSbdesilva]

Sharepoint, in a default group site setup by MS Teams.

• This reply was modified 5 years, 8 months ago by WSbdesilva.

This is Office365 in the cloud. Yes, part of that is Azure AD.

The originals are stored in one folder but once HR takes one to become live for a specific person that one is store in his private folder.

Thanks. I’d missed one of the places it was hard coded. It’s all working now!

Thanks again Maud,
I’ve integrated it into my spreadsheet and it works perfectly!
I did fail getting it to use a cell with the commission in it rather than embedded though. It calculated it differently. But I’ll figure that out later!

of course. Thanks!

Thanks again. Of course it gets more complex as the commission rate varies with amount sold across the year. For now I’m just going to implement this part of it and see how it goes. Thanks!

I do have a question about your screenshot though.
The second section saying two formulas equal GM is confusing as I don’t see how the second line is true GM # commission/.5 as far as I would understand.

As always Maud, you rock!

The name is Bryan, not Flip…
I have all that. The problem is commissions are part of GM and that to calculate commissions I need GM. Recursive algebra stuff needed in an excel formula!

Not to be flip but I’d go to the Accounting department and get the components of COGS numbers (materials, direct labor, etc.) leaving out commissions (they definitively should have these numbers) then just add them together and subtract from sales to get gross margin Before Commissions and the rest is easy peasy. Of course if you’re taking a math class and have to back into the numbers well that’s not what we’re here for :lol:.

Thanks! I’ll review this afternoon. As I said before, you are awesome!

I surely need help
I have a mock up file I’m using already that I can email if you tell me where, although I’d love to see what you have to do so I understand it. But you’ve already done so much just whatever is easiest.

oh my how beautiful this is! So I need just a little help getting it in my spreadsheet. How do I move what I need into my workbook, and how do I make it use the rows/columns of my model?

Thanks! That solved it.