I'm not sure if this is normal, but I have a simple automation to update a cell value when another cell value is changed. The trigger is working and the update works, but there is a significant delay …
I have a "test" project with many assignments that is connected to Resource Management. I want to delete the sheet and remove it completely from RM including all assignments. I disconnected the sheet …
I want to calculate the Start Date of a task using a simple formula. This is the Start Date column that interfaces to Resource Management, so that task and calculated Start date will be populated on t…
I've setup a "new project intake sheet" with a Form so that any PM can input a proposed new project. The form works fine and the sheet populates correctly. However, I cannot find the Form unless I fir…
I'm copying rows that meet specific criteria from multiple project sheets into a single different sheet using an automation. When looking at the destination sheet, is there an easy way to determine wh…
I want to take multiple actions when status of a task goes to Complete. I want to capture the status date I want to Lock the row from further updates I want to copy the row to another sheet (capture a…
I want to take multiple actions when status of a task goes to Complete. (Eg, the user changes the STATUS cell to "Complete" via a drop down. The following should all happen automatically via the workf…
I created a Form to enter a new row of data into a grid type sheet. The form setup was straightforward and worked fine except when it input the new row into the grid, it left a blank line between the …