Forum Discussion
PAULYEO11
Nov 11, 2020Copper Contributor
How to create share folder at SharePoint to share with my colleague ?
Hi All
I have try to create a share point folder , then i realize the folder was private group.
it cause myself unable to copy one file to folder. ( when i try to copy file to folder , error msg , access denise. i don't have permission.
i like to know how to create a folder which is not private.
Have no idea why, but you use binary search in XMATCH() /4th parameter/ which assumes sorting of data source. Try to sort Havi_Bér[Munkavállaló] in ascending order and you have totally different result.
I'd use default search mode like
=CONCATENATE( IF( INDEX( Havi_Bér[Szabadság], XMATCH($C$1, Havi_Bér[Kezdete]) * XMATCH([@Név], Havi_Bér[Munkavállaló]) ) > 0, INDEX( Havi_Bér[Szabadság], XMATCH($C$1, Havi_Bér[Kezdete]) * XMATCH([@Név], Havi_Bér[Munkavállaló]) ), "" ), IF( INDEX( Havi_Bér[Szabadság], XMATCH($C$1, Havi_Bér[Kezdete]) * XMATCH([@Név], Havi_Bér[Munkavállaló]) ) > 0, " nap, ", "" ), IF( INDEX( Havi_Bér[Apanap], XMATCH($C$1, Havi_Bér[Kezdete]) * XMATCH([@Név], Havi_Bér[Munkavállaló]) ) > 0, INDEX( Havi_Bér[Apanap], XMATCH($C$1, Havi_Bér[Kezdete]) * XMATCH([@Név], Havi_Bér[Munkavállaló]) ), "" ), IF( INDEX( Havi_Bér[Apanap], XMATCH($C$1, Havi_Bér[Kezdete]) * XMATCH([@Név], Havi_Bér[Munkavállaló]) ) > 0, " apanap", "" ) )
The same for Fizetendő, like
=XLOOKUP( [@Munkavállaló], Munkavállalók_Táblája[Név], Munkavállalók_Táblája[Alapbér], "Munkavállaló neve nem található a Munkavállalók_Táblája tábla Név oszlopában" ) * ( 1 - ( [@[Fizetés nélküli nap]] + [@Apanap] * 0.6 + [@[Beteg szabadság]] * 0.3 ) / [@[Tárgyhavi Munkanap]] ) + [@Túlóra] + [@[Utazási Támogatás]] - [@[Egyéb csökkentő]] + [@[Egyéb növelő]]
Not sure about other formulae, but you have to be careful with binary search.
3 Replies
Sort By
- ArefHalmstrandSteel ContributorYou have created a private team site with the name PBI Folder. Do you wish to make that site public? If so, log in to MS Teams, and go to settings for your team (PBI folder). Change the permission from private to public.
Yours sincerely,
Aref Halmstrand- PAULYEO11Copper ContributorHi Sir
Thank you- ArefHalmstrandSteel ContributorYou are very welcome!
If this helped you, could you mark it as best reply?
Yours sincerely,
Aref Halmstrand