-
Simple CountIf
I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?
-
If formula with number ranges
Hi can someone help me with my formula below. I would like the out come to be if the value in row (view265) is 49 or less to =1 if the value in row (view265) is 50 or more but less then 200 =2 if the value in row (view265) is 200 =3 =IF(VIEW265 <= "49", 1, IF(VIEW265 >= "50", 2, IF(VIEW265 >= "200", 3,)))
-
Transpose stacked cell values into separate columns
Hello, Is there a way to split a stacked cell values into multiple columns with formulas? So Col6 is the starting data that is dynamic, so it will change as forms are submitted so sometimes the cells have one name, sometimes they have 5. I'm hoping the output would look like the below Thanks for any help with this
-
Using Checkbox to Set the value of a second checkbox in same sheet
I have searched for awhile and have not found a solution. I have two columns. [Waitlist] and [Waiver Granted]. Both use Checkboxes. For this subset of data, [Waitlist] is generally true (checked) for each row. I want the user to be able to check the checkbox in the [Waiver Granted] column in one row and have itโฆ
-
I'm trying to calculate total cost of multiple criteria and receive the #unparseable.
I need to pull total cost savings that are within a specific quarter. In one sheet I have captured a column that has a dropdown lists Q1, Q2, Q3, Q4 where each row shows the savings for that particular line item. I now need to capture total sum of cost savings within each quarter.
-
Index Match Between Sheets Working Sporadically
Hello, I am trying to make a currency conversion chart where if a user in Sheet 1, can choose a dropdown in [Column9] and it will index match term with Sheet 2, matching [Primary Column] and returning [Column2] back to Sheet 1 in [Column8]. Sheet 1 Sheet 2 The issue I am having is that the Index Match will sometimes notโฆ
-
How to return a cell from another sheet when the criteria is within a text string in the source?
I'm trying to pull the notes from a Request sheet into the Review sheet, but I'm only getting results when the search criteria (Contract #) is the only contract in the cell in the Request sheet. Ex 1: Line 1 in the source, "123" in the Contract #, has "Urgent" in Notes; the current formula returns the correct notes intoโฆ
-
Recording Status changes throughout the course of a project
Hello, I want to record the change in the status of a symbol column. I understand that there is a "record the date" automation in place, but this automation gets rid of the previous date that the record was changed. I want to display on a dashboard every time the date has changed and what symbol it changed to. Please letโฆ
-
COUNTIFS with CHILDREN and Status Bar
I am trying to count the number of child rows that have a status bar symbol of Quarter, Half, or Three Quarters. Example: if 2 child rows are half, one is full, one is empty, and one is three quarters, the count should be 3 to account for the two halfs and one three quarters, and negate the empty and full ones. Just tryingโฆ
-
Lookup Cross Sheet Reference
I am having difficulty with writing a formula that will help me with cross-referencing two sheets for an inventory process. Sheet1 has numbers from a previous inventory date and Sheet2 has numbers from a current inventory date. The SKU in the column labeled Column1 in Sheet1 could also be in Sheet2. I have created theโฆ