-
Splitting Update Request
So, we send out quarterly update requests to various different departments...more specifically, to named individuals within those departments whose details are held within a Contacts column. These updates are timed so that they automatically go out a number of days before a data entry deadline. Due to the variation in data…
-
Planning : expected vs reality
Hello ! Does anybody know if how to show on the same line of the Gantt mode, the expected planning and the reality. Here attached is an example of what I need. Thank you for your help !
-
Is my alert too redundant?
Did I set up this alert to be too specific? I want to have an individual notified when a row to which they are assigned to has the status change to "In Progress". I'm trying to test it now but have doubts about the "In a row where any status is In Progress" line I included. The red in the picture is where my colleague's…
-
Send alert/notifications including headrow and children rows in the attachment
Hi All, I want to send automated notifications to my employees containing their absence records. To do so I need to be able to send their Head row (containing their remaining balance of sick days/holidays/bereavement leave ...) and their children rows (1 row per period of absence) as attachment. So far I can only do this…
-
Finding and returning values in a range of cells
Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certain value, and join them together. For example, say I had a row with 4 columns that say…
-
Alert(s) Updating a "Count" Sheet?
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
-
Re-using Update Request Links
Is there a way to re-use an Update Request link? For example, if I opened an update request and I am not ready to post a response, is there a way to open the Update Request again? The Update Request link is a one-time only link right? Is there a way to work around that? Thank you
-
Automated Update Requests based on 'Assigned To'
Hi I'd like to set up automated update requests to be sent out on a bi-weekly basis with a pre-defined set of fields to be completed in the update form. I don't have a trigger for this, I'd just like people to provide updates to their project, rather than trigger this from a change in a particular field. Any thoughts as to…
-
Overview of (Pending) update requests
As the Owner of many sheets I have to get into every sheet to see if there are still pending update requests. Is there a way to get an overview of every update request. Preferably in the More-section in the left-menu ?
-
Mutiple Contacts / Update Request / Form
Hi All, I have a column that has multiple contacts. I'd like to send an update request or form to each contact in the cell but I don't want one contact to overwrite another contact's information. I want to capture the information from ALL contacts in the cell. Questions: 1) Form or Update Request? 2) Is it possible to have…
