I am working on a metrics sheet where I'd like to count the number of items that a given department has implemented within in a specific year. In this formula {Date Implemented} is a cross sheet refer…
I am working on a ticketing system and would like to set up an automation to notify the submitter when their ticket's status changes but I'd like to customize the alert message depending on the status…
I am looking for a way to count the children of a parent row, but only if the children have a particular attribute that is true. I'll then use that count to set up an CountIF to flag the parent row wh…
I'm trying to find a workaround the lack of functionality in Update Requests. I have a Sheet Summary field called "Project Update" where our Project Lead is expected to put a brief statement on their …
Hey everyone, I am working on my first automation to move a row from Sheet A or Sheet B to Sheet C when the Approval Status is Declined. Sheet A is a list of a specific type of project and Sheet B is …
TL;DR I want to copy a cell from Sheet A (which has an inbound link from Sheet B) and paste into Sheet A while retaining the inbound link. Currently, when I copy the cell from Sheet A and paste into S…
