Hello All,

I am just playing around with my Intune test tenant and experiencing some issues on Scope tag. 

Created scope tag 1 which is assigned to admin1 (role – can read and write compliance policies, read and delete devices) (No other roles assigned)

Created scope tag 2 not assigned to any admin

Created compliance policy and removed the default scope tag and added scope tag2. My issue is, still admin 1 was able to read and write this compliance policy. Why this is happening and Am I doing something wrong?

​Hello All, I am just playing around with my Intune test tenant and experiencing some issues on Scope tag.  Created scope tag 1 which is assigned to admin1 (role – can read and write compliance policies, read and delete devices) (No other roles assigned)Created scope tag 2 not assigned to any admin Created compliance policy and removed the default scope tag and added scope tag2. My issue is, still admin 1 was able to read and write this compliance policy. Why this is happening and Am I doing something wrong?  Read More

​

I have an existing Windows 10 Pro PC that I can remote desktop to from any other Windows PC without any issues.

I just built a new Windows 11 Pro PC and have enabled remote desktop and I can connect and get to a login but the login always fails no matter what I’ve tried.

Both PCs are on the same network.  Both are logged with the same account and as far as I can tell, they are configured the same way, but the Windows 11 PC always says the login is incorrect.

What am I missing to get this working it’s pretty important that I can remove into my PC’s as I travel a lot and use them a lot remotely. 

​I have an existing Windows 10 Pro PC that I can remote desktop to from any other Windows PC without any issues.I just built a new Windows 11 Pro PC and have enabled remote desktop and I can connect and get to a login but the login always fails no matter what I’ve tried.Both PCs are on the same network.  Both are logged with the same account and as far as I can tell, they are configured the same way, but the Windows 11 PC always says the login is incorrect.What am I missing to get this working it’s pretty important that I can remove into my PC’s as I travel a lot and use them a lot remotely.   Read More

​

I have an input sheet with staff salaries – and starting dates etc to pull in monthly salary costs for forecasting. But also want a ‘profile’ to enable a user to input a revised amount (Usually upward) during the course of the next 2 years from the start of current year. These will be used to override the default amount on the calc sheet

Calc sheet has all  the breakdowns of everything. But I am trying now to incorporate the profile from the Input sheet into my basic monthly salary amounts. Looking for something like this. Ignore the combining with default values as this is straightforward. But I need the array of override values as below

I thought this would be quite easy but it seems not. As the periods will change from monthly to 3 monthly, one needs to sum based on dates. I have the start and end of period at the top so can do that. But the array of periods on the calc sheet does not match that on the input sheet which will just allow for 2 years of overrides, after which, simple inflation will kick in. Can’t really forecast salary increases going out more than 2 year and for new starts the default value (not shown here) will be used with a starting date. So this will only be used for changes during the immediate forecast period.

A simple sumifs does actually work for a single row but I want to create a full 2D array.

=SUMIFS(Inputs!$N$72:$AJ$72,Inputs!$N$71#,”>=”&L3#,Inputs!$N$71#,”<“& L4#)

Tried sumproduct also and used MAP function to map the starting ending dates of the periods

=MAP(L3#,L4#,LAMBDA(x,y,SUMPRODUCT(Inputs!$N$72:$AJ$72,(Inputs!$N$71#>=x)*(Inputs!$N$71#<y))))

L3 has the array of period start dates and L4 has the period end dates (Calc sheet). $N72:$AJ$72 holds the range of salaries for the profile and N71 has the header dates for the profile (Inputs sheet). This works fine as does a simpler Sumifs without the need to MAP. BUT. If I change the range of $N72:$AJ$72 to contain more than one row, I get a calc error. So fine on a row by row but can’t get it all in a single 2D array.

I tried ByRow in conjunction but that fails. Seems I can’t combine ByRow with another lambda function say from MAP or such. I also tried using a Reduce with VSTACK. One problem I see is that the array of dates on the profile is not the same as that on the Calc sheet period start & end dates and I can’t see how to align these in a clever way. Its not as easy as just mapping as the profile dates will always be in months but the Calc sheet is dynamic and the current year and forecast years can be set to 1,3,6 or 12 months. I even tried creating a THUNK for one of the lambda functions. But always get the calc error Because only sumifs actually seems to work with 2 dynamic ranges of different sizes, but I can’t use an input array with Sumifs (only a range – but it also deoesnt seem to work with BYROW) and Sumproduct needs me to use a MAP function (or similar) to match the date criteria in one range (actually in 2) to the criteria range of the profile, I can’t see how to avoid double nested lambdas. I was surprised that the ByRow didn’t work as a wrapper around the  map and sumproduct (Or sumifs)

Anyhow, I know there are so many super smart people out there, it is probably not that hard but for me, I’ve run out of options to try. I even considered a matrix multiplication but couldn’t get my head around that either!! I’m sure there is a solution using that.

PS. My attached sheet doesn’t use the same refs as described above. I put it together to illustrate the issues. Just took a camera pic and laid it roughly on top of the cells so that the refs – starting ones on some do actually reflect the above.

​I have an input sheet with staff salaries – and starting dates etc to pull in monthly salary costs for forecasting. But also want a ‘profile’ to enable a user to input a revised amount (Usually upward) during the course of the next 2 years from the start of current year. These will be used to override the default amount on the calc sheetCalc sheet has all  the breakdowns of everything. But I am trying now to incorporate the profile from the Input sheet into my basic monthly salary amounts. Looking for something like this. Ignore the combining with default values as this is straightforward. But I need the array of override values as belowI thought this would be quite easy but it seems not. As the periods will change from monthly to 3 monthly, one needs to sum based on dates. I have the start and end of period at the top so can do that. But the array of periods on the calc sheet does not match that on the input sheet which will just allow for 2 years of overrides, after which, simple inflation will kick in. Can’t really forecast salary increases going out more than 2 year and for new starts the default value (not shown here) will be used with a starting date. So this will only be used for changes during the immediate forecast period.A simple sumifs does actually work for a single row but I want to create a full 2D array.=SUMIFS(Inputs!$N$72:$AJ$72,Inputs!$N$71#,”>=”&L3#,Inputs!$N$71#,”<“& L4#)Tried sumproduct also and used MAP function to map the starting ending dates of the periods=MAP(L3#,L4#,LAMBDA(x,y,SUMPRODUCT(Inputs!$N$72:$AJ$72,(Inputs!$N$71#>=x)*(Inputs!$N$71#<y))))L3 has the array of period start dates and L4 has the period end dates (Calc sheet). $N72:$AJ$72 holds the range of salaries for the profile and N71 has the header dates for the profile (Inputs sheet). This works fine as does a simpler Sumifs without the need to MAP. BUT. If I change the range of $N72:$AJ$72 to contain more than one row, I get a calc error. So fine on a row by row but can’t get it all in a single 2D array. I tried ByRow in conjunction but that fails. Seems I can’t combine ByRow with another lambda function say from MAP or such. I also tried using a Reduce with VSTACK. One problem I see is that the array of dates on the profile is not the same as that on the Calc sheet period start & end dates and I can’t see how to align these in a clever way. Its not as easy as just mapping as the profile dates will always be in months but the Calc sheet is dynamic and the current year and forecast years can be set to 1,3,6 or 12 months. I even tried creating a THUNK for one of the lambda functions. But always get the calc error Because only sumifs actually seems to work with 2 dynamic ranges of different sizes, but I can’t use an input array with Sumifs (only a range – but it also deoesnt seem to work with BYROW) and Sumproduct needs me to use a MAP function (or similar) to match the date criteria in one range (actually in 2) to the criteria range of the profile, I can’t see how to avoid double nested lambdas. I was surprised that the ByRow didn’t work as a wrapper around the  map and sumproduct (Or sumifs) Anyhow, I know there are so many super smart people out there, it is probably not that hard but for me, I’ve run out of options to try. I even considered a matrix multiplication but couldn’t get my head around that either!! I’m sure there is a solution using that. PS. My attached sheet doesn’t use the same refs as described above. I put it together to illustrate the issues. Just took a camera pic and laid it roughly on top of the cells so that the refs – starting ones on some do actually reflect the above.  Read More

​

With a 2D array I wanted to replace any blank values on a row with the previous value. I found this which sort of worked. =SCAN(0, N72:AJ74, LAMBDA(a,v, IF(v=””,a,v)))

However, the accumulator value is carried forward to the next row so if there is a value at the end of the previous row, it is carried forward to the next row as SCAN just works its way through the array. I want to treat each row independently so that there is nothing carried forward to the next row.

I tried with ByRow but this caused a  calc error. Couldn’t find a way to ‘get’ the row number or to determine the row had changed and thus be able to set a to 0. Or, to get ByRow to work which would have been the easiest.

This could apply to the MAP function too as getting the row and column index could help determine a new column or row

​With a 2D array I wanted to replace any blank values on a row with the previous value. I found this which sort of worked. =SCAN(0, N72:AJ74, LAMBDA(a,v, IF(v=””,a,v)))However, the accumulator value is carried forward to the next row so if there is a value at the end of the previous row, it is carried forward to the next row as SCAN just works its way through the array. I want to treat each row independently so that there is nothing carried forward to the next row.I tried with ByRow but this caused a  calc error. Couldn’t find a way to ‘get’ the row number or to determine the row had changed and thus be able to set a to 0. Or, to get ByRow to work which would have been the easiest. This could apply to the MAP function too as getting the row and column index could help determine a new column or row  Read More

​

Hi! I have tried finding the answer to this on my own, and am now turning to the community. I have started using Lists today, and I am looking to add a calculated column to calculate future dates. However, I am in the “preview” view and don’t have any option to add this type of column. This type of column simply does not exist in my options, and I also don’t have any column options in the settings view.

I have tried to see if there’s an upgrade I need, a different type of account, etc., but have found no guidance. The closest to an answer I received was that I might not have admin permissions, but I’m the only user of my own account. 

Can you help me? Thank you! 

​Hi! I have tried finding the answer to this on my own, and am now turning to the community. I have started using Lists today, and I am looking to add a calculated column to calculate future dates. However, I am in the “preview” view and don’t have any option to add this type of column. This type of column simply does not exist in my options, and I also don’t have any column options in the settings view. I have tried to see if there’s an upgrade I need, a different type of account, etc., but have found no guidance. The closest to an answer I received was that I might not have admin permissions, but I’m the only user of my own account.    Can you help me? Thank you!   Read More

​

How can I enter ABC in one text field and it should automatically write it in the second text field too.

​How can I enter ABC in one text field and it should automatically write it in the second text field too.  Read More

​