Hello! I am working in a sheet where I need dependencies enabled because we are using the GANTT view to show in a report on a dashboard, however I also need the end date of that sheet to be calculated…
Hello All, I was wondering if anyone has found a way to have a link/button in a subsection of their project plan (for multiple different lines in the plan) where they can click and bring up a blank me…
Hi All! I'm back with another project for work. This time I am trying to auto assign values to a column. Essentially we have tasks as rows, and one of the columns in the row is percent completed. I wo…
Hello, I currently have the following asset booking sheet: What I'm trying to do is, for the column 'Assignee in Possession Before Your Booking Date:', if the asset is available within the booking dat…
I am asking for assistance on a report layout. We have 15 Regions. Each Region has small teams. I have some team members that are on several teams. We have a column called “Region” that is a multi-sel…
Hello! I'm having trouble finding a way to exclude a status from this formula: =IF([Total on PTO]@row < 2, "Under Limit", IF([Total on PTO]@row = 2, "At Limit", "Over Limit")) It's referencing another…
Hello, I am encountering an issuing when trying to sort the information in my sheet that is being displayed in a chart. When I sort on the columns that contains a metric that I am displaying it reduce…
On calling the following api, getting the "SUCCESS" message but sheet is not shared to the owner. Is there any way so that the sheet can also be shared with owner through an email?
Hi! I've been using the MIN and MAX children functions to roll up dates from child tasks, or sub-tasks, to the parent task. I also want to create a column that looks at the dates of each sub-tasks and…
For instance, how can I make the column only show me the last 4 digits within the column itself. So that we can enter the last 6 digits via a Form, but it only shows the last 4 digits within the sheet…
