-
Is there a FORM ID?
I have multiple forms that can be used to submit data to a worksheet, and I'm wondering if there is a FORM ID that could be used in a column so I know which form was submitted. If yes, is there a specific formula I can use in a column to identify the Form ID and Name of the form?
-
Index/Match Formula Behavior
Hello, I'm encountering an issue with the INDEX/MATCH function. When the value in the cell being match does not find a match and is recognized as text rather than a number, the formula does not return 'no match' as expected. Instead, it displays the last entry in the reference range. Formula in cell Category Index/Match…
-
how to fix #DATE EXPECTED from collect formula or index
I am using the collect function to pull a start date from a project sheet (which has project setting enabled) with two criterias. first criteria is to reference a task name and second criteria is pulling another column
-
Column Formula to populate a Helper Column
EDIT: I just realized this is listed in the Add Ons and Integrations section rather than elsewhere, but I cannot move it. I have created separate helper columns to return the value in [Plan Start Helper] for any of the matching [Opp #] where [Plan] contains the word "Plan" (I have other helper columns that need to search…
-
List an ancestor value if a child meets a condition
I am trying to write a formula to return the value of an ancestor if a checkbox cell is checked. For context, I need to see if the ancestor and all child cells are relating to an event. The sheet has a mix of events and other projects, and there is a checkbox column to mark if it's an event. The checkbox is checked at the…
-
AVG formula #DIVIDE BY ZERO
Hello, community! I have a question. I'm using the "IF" formula to calculate a percentage based on the status in the "status" column. now, I'm trying to calculate the average of those rows, but I get a "#DIVIDE BY ZERO" error when I use the formula AVG. How can I resolve this?
-
Need the minimum start date for projects, what's the formula?
I'm trying to get the formula for the min start date based on the project number. So in the chart below the minimum start date for project 1 should be 11/5/24.
-
Combine Multiple IF statements
Hi! I am trying to write a formula that returns "Yes" when all expressions are true. I have written four IF formulas, that work independently but cannot figure out how to combine them. My final formula will not move past the first expression. Here are my criteria: IF Procurable is Yes, TBD, or Blank =IF(OR([Procurable]@row…
-
Count # of cells approaching a date for sheet summary
I'm trying to create a sheet summary field that counts the number of cells in a column that are less than a week from the date in the cell. This is what I've tried: =COUNTIF(Off-Site to On-Site Return Estimation:Off-Site to On-Site Return Estimation, TODAY(<7) Thank you for any help!
-
Variance on time or behind schedule collumn
hi, can anyone help me create a column that tracks if my variance column is above or equal to 0 then return a value of “on track” if the value is below 0 then return “behind schedule” BUT return a blank value if the variance column is blank.