-
Urgent Help - How to add currency symbol + Correct Price Commas to Cell
Hi there, I'm after some help as im pulling my hair out - I am trying to pull over the correct currency symbol and the right pricing commas for example $85,450 or C$85,450 - I currently have a formula set-up in the currency symbol field for whenever someone selects the currency drop-down in the form in correctly populates…
-
Help to create a "3 Dimensional Reference" Formula
I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.
-
Why is the overall % percent project complete showing 99%?
Help please. I am testing the plan rollup template. My question is why is the overall % percent project complete showing 99%? Initiate = 100 Planning & Discovery = 1 Build & Implement = 0.99 Closing = 0
-
V Lookup formula for importing Contact List broke and I don't know why.
So I have a reference sheet of contacts and their assignments. I made a different sheet to assign tasks as they come in and set up an equation to look up and auto assign. It looks like: =VLOOKUP([Rule Number]@row, {Committee Range}, 2, false) So when a task came in and it matched the rule, it would assign the person in the…
-
Help putting data in the correct column automatically
Hello. I'm working with a worksheet where I'm trying to put a Workers management team into the correct column based on the Managers Management Level. I'm able to see the flow of an organization by using an INDEX(MATCH()) formula (=INDEX({Manager}, MATCH(Worker@row, {Worker}), 1), but how do I get the data to show up in the…
-
Too many Cell References Error
So i am making a sheet to keep track of different devices i mangage. While doing this i ended up with a lot of duplicate columns (Ex: Description column and another column named [DESCRIPTION] with the formula "=Description@row") Since getting the too many cell references error i deleted about half of the columns i had and…
-
Odd bug in Date formula?
So here is something I have been trying to tweek with no success…. I have this column formula which takes the date in column A and gives me the updated date of same month, last day + 2 yrs (ie 11/01/24 becomes 11/30/26) =DATE(YEAR([Appointment Month]@row) + 2, MONTH([Appointment Month]@row) + 1, 1) - 1 and it works great…
-
Countif -- based on separate row , eliminating certain responses
I have a helper row to create a 1st, 2nd, 3rd place in my Summary Tab. But it is counting all entries by participants regardless of the Activity. The Activity selection is a series of drop downs, but I want to eliminate "Training" "Lunch". The current count formula is =COUNTIF([Mtn Safety]:[Mtn Safety], [Mtn Safety]@row) I…
-
Nested IF with IF(OR statement not working
I am trying to set dates based on country - the US, CA, and UK are singular, whereas the EU, APAC, etc, have many countries (using OR). =IFERROR(IF(OR(GEO@row = "US"), [Req. ETD Date]@row + 31, (IF(GEO@row = "CA"), [Req. ETD Date]@row + 55, (IF(GEO@row = "UK"), [Req. ETD Date]@row + 56, (IF(OR(GEO@row = "EU", GEO@row =…
-
Index Join Collect - gather list
I want to create a formula that gathers a list of zones by identifying the area. Column A is the area, Column B are all the zones that are under each area. In the related form, the person enters Column A area and adds a zone to Column B that is under that particular area. As the list of zones builds with each form issued,…
