PowerShell: Generate a report of all items across a site collection where a column has a specific value

I am trying to come up with a script to do the following in my SharePoint 2013 environment, and have not had much luck.

I need a script that will generate a report/csv that will give me the value of a site column when it has a specific value.

For example, say I have a site collection at http://test/site, and a site column named “State.” That column is used in multiple lists throughout my site collection. I need to generate a report which shows all instances of items where State Column = Texas.

Thanks for any help you can provide.

TEXTJOIN across multiple sheets and IF

I am trying to use TEXTJOIN across multiple sheet, IF a cell is is the same I would like it to return the value from another cell in all sheets that is associated to it.

In this example I am trying to look up the value on Sheet1 and Sheet2 for code in $ B$ 4:$ B$ 7 22155… and to retrieve the associated $ D$ 4: $ D$ 7 AAA and/or BBB and TEXTJOIN them ” – “.

I have tried TEXTJOIN and combining the IF and also VLOOKUP but my brain just can’t seem to work it out. This will be along a larger range of sheets and 100+ CODES in each sheet.

Any help with this would be greatly appreciated.

enter image description here

iPhone/Android Nearby Filesharing Systems Across Platforms

In the past, I have been excluded from group chats, denied entry into groups and overall discriminated against because I have an Android while almost everyone I know has an iPhone. I have been trying to find ways to integrate iPhone and Android functionalities, to bring the two platforms closer together. I had found the app “WeMessage” that would allow an Android user to use iMessage, but I haven’t set it up yet. Next, I wondered if there was a way to send and receive using the iPhone’s AirDrop functionality on an Android. My phone, a Huawei Mate SE, has a function called Huawei Share, but it only works with other Huawei phones. So does anyone know how AirDrop works or how one could use a nearby filesharing system across platforms?

How can I create a unique list of data across multiple rows AND columns?

Google Sheets has a UNIQUE() function which when given a column of values, will output a column of all unique values.

This works well for column-specific data, however, you have multiple columns and rows of data that needs to be summarized, this won’t work. This is because if you include a 2-dimensional range into UNIQUE() the end results are two dimensional, with only each column being summarized.

Is there a function or way to summarize all values across an entire 2-dimensional range?


I have a large list of businesses. Each column is a type of business, and each row contains values of business names. I need to create an end-list of all businesses that are provided throughout the entire source sheet. I don’t need unique values per column. I need unique values across the entire document.

Running formatting script across multiple tabs

I have an onEdit script I’m using to protect/force formatting on a single tab within a google sheets document – and it works perfectly.

The issue I have is that I’d like the same script to work on multiple tabs of my choosing, but I’m not sure how to go about that. I know you can only use the onEdit function once, but I don’t know how to set up an array that allows me to replicate the script across other tabs. Here’s the script I’m using.

    } function onEdit(e){             var ss = SpreadsheetApp.getActive()   var sheet =ss.getActiveSheet()   if(sheet.getSheetName() == "NEWS"){   var entryRange = e.range   var range  = sheet.getRange(1,entryRange.getColumn(),1,entryRange.getNumColumns())                 Logger.log(entryRange.getA1Notation())   range.copyFormatToRange(sheet, entryRange.getColumn(), entryRange.getNumColumns()+entryRange.getColumn()-1, entryRange.getRow(), entryRange.getNumRows()+entryRange.getRow()-1)   Logger.log(entryRange.getColumn())   if(entryRange.getColumn() == 10){                                      if (entryRange.getRow() != 1){                                      e.range.setValue((e.oldvalue == undefined? "": e.oldvalue))     }   }   } }  function setFormat(){   var ss = SpreadsheetApp.getActive()   var sheet = ss.getActiveSheet()   var firstRow = sheet.getRange(1, 1, 1, sheet.getLastColumn())   var dataRange = sheet.getDataRange()   firstRow.copyFormatToRange(sheet, 1, dataRange.getNumColumns(), 2, dataRange.getNumRows())   } 

Any help would be much appreciated!

How can I use a script across multiple pages of a Google Sheet

I’ll start by saying I’m very new to this. Here’s my problem. I have a GoogleSheet I created to use as a seating chart in my classes. It is designed so that when I click the blue check button the cell where a child’s name will appear turns green. It can then be reset by clicking the recycle button in the corner. All of that works fine but only on the first tab of the sheet. I would like to use it across all six tabs, one for each class I teach. Can anyone show me how to share the script across all six sections. Here is the basic code I used:

function A3Green() {   var ss = SpreadsheetApp.getActiveSpreadsheet();  var sheet = ss.getSheets()[0];    var colors = [     ["#00ff40"]// These are hex equivalents   ];     var cell = sheet.getRange("A3:A3");    cell.setBackground (colors); } 

Best Practices for managing Active Directory across Dev, QA, UAT, & Prod environments

Long time listener, first time caller. I’ve recently been promoted to my first Systems Analyst gig – and I’m very excited, if not a little green.

My organization just launched a a new in-house application that our Dev team has been working on for a few years, prior to my arrival.

Now that the application and integrations have been released to the production environment, the DevOps team is re-architecting the CI/CD pipeline, to be sure that each enviro is firewalled from each other. We have Dev, QA, UAT, and Prod environments.

The Developers are pushing hard for scripting everything, so that environments may be torn down and built up as needed. Of course, all the non-Prod environments need to mimic the Prod enviro as much as possible. Currently, Active Directory services are structured as a single forest, single domain.

Our shared concern is that – upon scripting the creation of the enviros, including AD elements (e.g. user accounts, service accounts, security and distribution groups) – we could inadvertently cause an undesired change to our single AD, which of course, is responsible for all production authentication (e.g. users, computers, etc…).

My question: What are some best practices for DevOps teams in terms of architecting/managing/isolating Active Directory across environments? Should we create another forest, with a trust relationship? Or maybe a child domain in the existing forest? Or something totally different?

If all the environments are uniquely their own – that is, firewalled and isolated from one another, but all reach out from within their isolation to have a “touchpoint” in a single AD, how is this best managed?

Looking forward to any guidance, and yes – I have been Google-fuing/researching independently of asking here. Just thought this community might be a good place to continue my search.

Please – if I haven’t provided the necessary information to appropriately answer the question, just let me know.

Thanks in advance.

Multiplication Sums across cells?

Example image of what kind of thing i need

I know this isn’t very professional but i’m very very new to google sheets and spreadsheets in general.

So if I know that Tier 4.3 leather is worth 6 points in the contest, someone brings me 739 of them along with 589 Tier 6.2 ore. Is there a way i could type 739 and 589 in the table on the right hand side and set up a formula in some way to allow the sheet to calculate how many points this person earned for that resource? Then i would just manually delete the values once i have a final number and start on the next person.

If anyone has any tips or favourite places to look where i can learn how to do things like this for myself that would also be amazing. I’ve taken to google but I find the jargon and terms a little daunting!

How similar should the same app be across different platforms?

How similar should an application be across different platforms (iOS and Android) in case of a) visual design and b) interaction design (patterns on how to achieve a certain outcome).

I am not quite sure, since both platforms tackle certain interactions in different ways and also recommend specific design patterns. I am aware that the most basic things (like navigation bars/header) should be designed for each specific platform as users already know these things for their device, but when it comes to input fields for example I am a little lost.

Maintaining 2 different “design system” (1 for each app) is really slowing down my process when it comes to new features or general improvements.

Hope anyone here can help me out and give their opinion on this topic. (:

EDIT: I forgot to mention: Both iOS and Android are developed separately (Swift + Kotlin)