-
IF statement with returning value -> if value blank, place a zero
Hi, I am trying to fill in a row with numbers from a pivot sheet I created. If the pivot value is blank, I need a zero to be placed in the field the blank value is returning to: IF(NOT(ISBLANK(INDEX({Pivot sheet Active value range}, MATCH([Identity ID]@row, {Pivot sheet Identity ID range}, 0)))), "0"). This formula is…
-
Cannot convert to column formula
Hello, I've been banging my head against this issue and have not found a solution. I'm trying to convert a working formula into a column formula but keep getting a "not quite right" error. I thought other parts of the formula were incorrect so I removed them to see if that was the case but it's not. I know having an…
-
I have a parent row that needs to populate with appropriate 'Status' based on it's children
I have many parent rows with many children, in some cased grandchildren. Each child (or grandchild) has a status. Status choices are; Not Applicable Not Started In Progress Complete I have to account for the following possibilities; I have been able to write a formula for the first 4; I am having great difficulty writing…
-
Creating a Daily Total Sheet from another Sheet that Updates Daily
Hi all, I am having trouble finding the best practice for this and thought it might be easier to ask here. I have my "Main Data" sheet that gets replaced daily through a Data Shuttle workflow. I need to create a helper sheet that totals the count of one of the columns and keeps track of the totals for each day. For…
-
Linking External Sheets for Conditional Formatting
I am currently working on conditional formatting for a spreadsheet that connects to several spreadsheets. We have a Master Log (spreadsheet) that pulls project dates from multiple Project Schedules (Gantts) so we can keep track of project timelines of milestones. We have roughly 45 fields. 17 fields are linked to Project…
-
I am trying to create small chart for dashboard
I have a master sheet that has 100 projects all different end dates. Trying to find a formula or method create small chart like a sample Jan 2022 - 4 Feb 2022 - 3 Mar 2022 - 4 Etc...
-
How to use a formulas to indicate current constellation in sheet summary
Hi guys, I have a sheet to indicates constellations by date, and I cannot find a formula to get current constellation based on today's date, can anyone help with this? Much appreciate!
-
IF Formulas including Blanks and AND / OR
Hi I'm looking for a formula that will show me whether a deadline has been met. My Deadline Met formula is currently only taking into account the Agreed Deadline Date and the Date Completed =IF([Date Complete]@row <= [Agreed Deadline]@row, "Yes", "No") However, what I really need it to do is also check if a). There is a…
-
IF(AND Formula + substraction
Hello! I have the % Burn Rate of my project and the % Complete, I want to subtract and according to the difference in them I want Harvey Balls to display different colors. If the difference between the % Burn Rate and the % Complete is => 6% I want it to be "Red" If the difference is From 1% to 5% I want to be "Yellow" And…
-
Duplicate Entry Formula for Data Across Multiple Columns
Hi, I'm hoping someone can share the correct formula to indicate a Duplicate entry where all multiple columns all have to be 'true' for the indicator to show a duplicate row/entry. Example: To trigger the "DUPLICATE ENTRY' status, I want to make sure SITE, BLDG, ROOM, and DESCRIPTION/CATEGORY all have the same value, not…
