If I have a multiple selection column, like 'assigned to', where I can select some or all of the people, can I determine which specific people from the list have been selected (without using FIND or C…
Hi - I have a request to create a sheet where a team member wants to input data, and then send a form link out for additional information to be collected. We would all of this information to be popula…
Hi everybody, been melting my brain trying to get this one I have a bunch of project sheets set up to send their rows back to a central tracking sheet. I have a Master Status sheet that parses that tr…
I have built an audit for the operations folks to fill out and submit via Forms. They are wanting to have their score automatically appear on the submission confirmation page so a few questions: Is th…
The grid below shows 3 rows. The 1st, Header_Row, is a place holder row for the Today function entered in the 1st cell of the Date.Today column. This allows the formula to be copied down when subseque…
Hello, I am trying to count grandchildren rows based on 2 column criteria. My parent row is different task orders and underneath are multiple children(Hospitals) and the children all each have childre…
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here…
Hi, I have used the formula =IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1) in the flag column to turn the flag red when the end date is passed and completion is less than 100% which is gr…
Hello, All of my Parent rows are expanding automatically when I have a filter on. This happens every time a member of my team refreshes the page. Is there a way to have my filter on and keep the Paren…