We want to create a new workspace but only want certain people to be able to access that workspace. Will system Admins be able to see the work space if there is some data we don't want some of the sys…
Hi, My teams work concurrently across multiple projects. Is there a way to combine status update requests for tasks across multiple sheets so that they receive a consolidated update request for all pr…
Hi - Is there a way to automatically reset a date when a task is complete? So when a task is done I click the check box and it will automatically reset the due date to the next business day on daily r…
I have a file with two workflows. The first workflow is an update request which is sent on Thursday's. The other workflow is to notify the owner if a cell was not updated as requested. To trigger this…
I have a column that organizes my tasks (rows) by priority. So, my highest priority is 1 and my lowest is 10, etc. When I add a new task to the spreadsheet and I decide that it is now the highest prio…
Hi All picking your brain here on formulas cant make it work, I am looking to count if: In my column A the name is DC380 and if corresponding at the value in column A, the value in column B and C is "…
I'm trying to figure out if there is a formula that can be used with forms that would alert someone if they pick a date that is taken already. have a sheet with a list of class dates, and I'm using a …
I need to create a form that allows folks to request materials from inventory; part, description, quantity, etc. when they submit the form it should then go to the Materials team to fulfill. how do i …
Hi. I have active contacts from my contact list in Children row. I would like to bring them together in one cell in parent row. I understand function COLLECT needs to be used with another function. If…
Hello All, I have a manufacturing schedule sheet which lists tasks that are sorted by date. I have a bunch of conditional formatting rules applied to make things easier to read and identify. Each day …
It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…