-
Countif a value AND Completed Date not Blank
Struggling with the right equation. Completed Date Column has no end range (rows can continue to be added at anytime via a form). Size Column has many different sizes 32, 40, 50, 60, 72, 80, 100, 106 that can be in the column. In additional columns I have a column for each size. I want to count how many size 32 I have IF…
-
Formulas
I would like to have a nest If / Then formula that is dependent on the %Complete Column. EX: =IF([% Complete]9 = 100%, "Complete", IF([% Complete]9 = 0%, "Not Started","Pending")) I am getting the #UNPARSEABLE error. Thanks in advance.
-
Conditional Formatting or Formula?
s it possible to create a formula or a conditional formatting rule that would automatically highlight any child rows as they are created and/or based on a specific term or text in a column of the parent row?
-
Getting value from Parent column
In the example below, I have a column named "Task Name" which contains "Version 1.0" and a column named "prefix" which contains "1.0" In the row Task A, I want to pull in the value "1.0". I was hoping to reference it by using =PARENT() Can someone show me how to do that? I have had no luck. =PARENT() provides a reference,…
-
FORMULA - Estimated vs Actual Time
FORMULA HELP NEEDED (See Screenshot) I need help creating a formula to show: IF "Actual Time" Column is 10% more than "Estimated Time" Column, then "ERP vs ACTUAL" Column shows "DOWN" Symbol IF Not, shows "UP" Symbol. Times are entered in minutes (00.00) Thanks in advance! This is what I currently have: =IF(AND([Actual…
-
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
-
adding conditions to recurring reminder formula
I'm trying to expand on this formula that triggers a recurring reminder (explained here: https://www.smartsheet.com/blog/support-tip-recurring-reminders): =IF([Flag1]1 = 1, TODAY(), "") I want the return value to equal today if the flag is checked and another date cell is in the past. I tried a bunch of variations and made…
-
SUMIF using dates
I'm trying to use the SUMIF function to calculate the total in Column A when the date in Column B is less than or equal to 10/2/17, but haven't been able to make it work. Please advise.
-
Need help with getting parent and sub parent data
I have a format that looks like this Project Name PreCon Name Name Construction Name I am looking for a formula that adds text to a column for each name structured as "Project Name - PreCon" or "Project Name - Construction" I can get it to work using explicit references =PARENT([Task Name]13) + " " + PARENT([Task Name]14)…
-
Help with date formula
Need formula to calculate a date: Spreadsheet has (3) Columns as follows: Cal Type (drop down) with 2 options - In-house or Third-Party Next Cal Date: Date Reminder Date: Date Would like formula to calculate the following If/then scenario: If value in Cal Type is "Third Party" then need Reminder Date to be Next Cal Date -…