-
Gantt Bar with milestone
Would be extremely helpful for high level reporting to be able to have a parent row which is showing the overall Gantt bar be able to display a child row as a milestone marker along that bar. Our project portfolio would benefit from being able to show the go-live milestone that is occurring during the project execution…
-
Using "Modified" to Trigger Automation
In my sheet, I have a column labeled [Status] that indicates the current stage of development for a program. The values can be Stage 1, Stage 2, Stage 3, Active, On Hold, or Archived. I also have two columns labeled [Stage 1 (Decision)] and [Stage 2 (Decision)]. These are used to capture the decisions by management at the…
-
Attaching entire sheet of specific rows to a notification...
Odd problem but for example I would have a sheet of subprocessor vendors that includes a category, name, address, business line and other fields, when I add a new vendor to that list I would like to notify the customers who have requested that information of the new vendor name, address and category only, as well as all of…
-
Drag a cell which cotain cross reference cell
Hi there…. I am using a budget sheet that collects the figures from multiple sheets. I am using the SUM function for each cell "SUM({Office-01 Rent}, {Office-02 Rent}, ……..)" Is there a way to drag the first cell and automatically the cell reference is updated same as in excel?
-
column formula error!!!
Hello and have a nice 2025! I want to set up a column formula about completion progess. In 2 column one is called %complete , another is called Completion progress, for example I enter 50% on the column of %complete and I want the completion progress column to show me the progress bar immediately , I type the formula in…
-
Tracking Time a Project Stays at Different Stages of Development
I have the following three sheets: SHEET 1 (with proposal form): Used to collect form submissions. Once reviewed, row is automatically copied to SHEET 3. SHEET 2 (with approval form): Used to collect form submissions from the management team. The form includes the following fields: Program Code, Stage, and Decision (drop…
-
Calculating date/time on "Created" and "Modified" column types due to API time zone issue
Hello, We are needing a document to generate with our local time zone based on the "Created" and "Modified" date/times. This used to work correctly, however for some reason the past few weeks it's now generating with UTC instead. We need it to generate with UTC-8. It looks correct on the sheet, but the generated document…
-
Assign a Program Code, without using Auto Number
I am already using the Auto Number column, but I want to generate a unique [Program Code]@row for each new program added to a sheet, starting with 5,000. However, I don't want to assign a Program Code to a program added to the sheet, if the [Program Name}@row is a duplicate of an already existing program. Program Code |…
-
Project Metadata Sheet
=VLOOKUP(Month@row, [Month Vlookup]:[Month Vlookup], [Month Name]:[Month Name], false) What am I missing? #INVALID DATA TYPE is what Im getting
-
IF(AND(OR? Formula
Hello - I am trying to write a formula for the following functionality: I have one column that is a checkbox, one column that is either "Standard" or "Non-Standard", and I want to calculate if the checkbox column is checked ([Needs Replacement]@row=1), AND if the [Room Type]@row="Standard" - then do this calculation…
