-
Replicating a Excel formula in Smartsheet
I am trying to replicate a formula in Smartsheet from an Excel formula. However, Smartsheet is returning an #INVALID REF error. I have attached a picture of the formula in both formulas. ANy guidance would be appreciated. EXCEL…
-
Budget Rollup based on used Resources
I currently have this formula for my budget =IF([Resource Helper column]@row > 4, [Quoted labor budget ]@row - (200 * ([Resource Helper column]@row - 4)), [Quoted labor budget ]@row). I want to do a roll up each time an additional resource is added in the child rows and any additional rows for created for each project. Im…
-
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…