-
Index match formula but for specific values of column
Hi team, I have region, I'd and manager columns I am using index match formula to get manager updated from another reference sheet based on identifier I'd. But i want this formula to be applied for only cell with region as Asia for example How to achieve this?
-
Counting cells that are not blank
Hi, I need to count the cells in a column that are not blank. This formula is giving me an unparseable error: =COUNTIF({Date Converted from DataCor to Exp Lite}:{Date Converted from DataCor to Exp Lite},<>"") Thanks!
-
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…