-
Reference Formulas in Templates
Hello, I have created two templates from sheets that reference each other in a SUM+DATE formula. I would like the new sheets created by the template to reference each other, but at this moment they reference the old sheet from which the template came and need to be changed manually. Any way to achieve this? Thanks in…
-
INDEX/MATCH formula has me stumped
I am trying to understand a formula that someone else has written and I cannot get it. It works great but I do not know how and I would like to. It looks like this: =COUNTIFS(INDEX({EDB Full Range}, 0, MATCH([Equipment / Limit Required]@row, {EDB Full Range}, 0)), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate},…
-
Returning Text if JOIN(COLLECT(...)) unable to make a reference
I noticed that, if JOIN(COLLECT(...)) is unable to make a reference, it just returns null. I am drawing a blank. How can I cause it to return text instead?
-
Intergration: connector question
Hi Team, A quick response will be great help. I have a sheet 'A' which gets data from another sheet 'B' and its a link in form of cell linking or a column formula. and now this sheet 'A' i am creating a connector to transfer this information to Salesforce so i have this data(link) copied into Salesforce account. So my…
-
Automatic Project Phase Formula
Hello, I am wanting a formula that returns the current project phase. The phases include Initiation ,Planning, Execution, Testing, Implement, and Closing. I want the formula to return the text value of the phase that has the least % started, NOT including phases at 0% or at 99% and higher. In the example below, I would…
-
Is there a prettier way to write this formula?
Is there a prettier way to write this formula? =IF(MONTH(Finish@row) = "1", "Q1", IF(MONTH(Finish@row) = "2", "Q1", IF(MONTH(Finish@row) = "3", "Q1", IF(MONTH(Finish@row) = "4", "Q2", IF(MONTH(Finish@row) = "5", "Q2", IF(MONTH(Finish@row) = "6", "Q2", IF(MONTH(Finish@row) = "7", "Q3", IF(MONTH(Finish@row) = "8", "Q3",…
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
Get total cost based on multi select
Hi everyone, I have a total column that I want populated with a dollar amount. I want this to be dependant on the specific services selected from a multi select. The trick here is that the services rendered are completed by different vendors with different prices. So, the multi select prices will change based on the…
-
Symbols and formulas
I have a sheet that has 4 dates on it that I want to use symbols for completion purposes but I cannot figure out the formula or if it is even possible. I am trying to use the status bar with Empty, Quarter, Half, Three Quarter and Full. Here is what I would like to happen. If Date 1-4 are greater than today I want it to…
-
How to count on another sheet how many terminated employees per month?
Hello, I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month: =COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2}) What am I doing wrong?