-
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?
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Formula Help Countifs and Match
I'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment Total}, 1), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate}, <=[Last…