-
Why would the absolute reference change after sorting on a column?
I am creating a weighted score card. All my formulas appear to work as expected, with the exception of the Rank formula. Whenever I sort the sheet by either Team Member or Manager (both are setup as contact lists) the Rank function returns a #NO MATCH error for some of the rows. Prior to sorting, the RANK formula is:…
-
Returning cell based on 2 criteria in another sheet
Hi, I'm back! I am trying to pull the course cell per semester based on a student's ID and also on the Term (fall or spring) columns. This sheet is my "eligibility sheet" where I would like the course from my Active TAships sheet to go Active TAships Sheet: The formula I am using in the FA Acceptance (also will be in Sp…
-
Linked cell not working
I have linked my plan cell with another cell from another plan (it was task status btw), so it will serve as reference for my plan when my dependency task is complete, I can proceed with my tasks, but the content of this cell is not updating (the other links I did worked). What could be happening? thanks.
-
Move Row to New Sheet
I'm trying to figure out how to move a row that contains "New Trip Report" when a new row is added containing "Corrected trip report" and the Report ID's match. For example: see screen shot. Adding row 2 containing Report ID TR00001TX115 would trigger moving row 1 to a new sheet. If anyone knows how to do this, please let…
-
Problem with save as new and column formula
Hello, I have a spreadsheet that has some column formulas in it. I did a "save as new" and deleted some columns that had formulas in them in the copy of the original spreadsheet. For a reason that I don't understand, the formulas in the original sheet stopped working. I don't see how modifying the copy changed the…
-
Formula help needed: multiple combinations
Hello, I am in need of help with a formula. Basically, I have a formula looking at column A. Column A has 9 drop-down options, multi-select. Each of the 9 options has a specific (i.e., different) email associated with them. I have a large IF function that will accurately give the appropriate email, based on a single…
-
need help on a SUMIF formula to sum values if any of several drop down options are selected
I need a formula to sum all values in a column if that row has selected certain drop down menu options. The drop down menu is single select, but I am only interested in summing the values if the row has selected any of the first 6 options from the drop down menu. Here are the options in the single select drop down menu: 1…
-
Formula columns not updating automatically after data is pulled in via datamesh
We discovered that our formula columns are not updating automatically after data is pulled in via datamesh and they only update if someone goes into the sheet, clicks into some cells, then saves the sheet. Support told me to set up an automation on the sheet that does something like locking then unlocking a specific cell…
-
Working with dynamic cumulative fractions
I am trying to create pareto charts for dashboards. I am referencing a sheet where I create totals and counts etc. One is a count of total items in a team. Impact =(Count@row / (SUM(CHILDREN(Count$2))) to get percentage for items for each team overall. Cumulative is for Pareto charts =SUMIFS(Impact$3:Impact$20,…
-
Count if a cell is blank / not blank
I'm trying to create a formula to help show when tasks are past due. Basically, I want to count cells where Range 32 is NOT blank (or is a date) and where Range 31 is blank (or is not a date, as it has not been filled in yet). I don't think this format is correct at all, but I'm struggling on where to go next.…
