-
Index Function Has Stopped Working
Has anyone else experienced this as of 2/19/24? In Control Center, many of my sheets that use Index have suddenly had the formula fail to work. These are sheets where they were previously working with no problem. Troubleshooting eliminated the idea the problem was with Match (correctly returns the row index), but even when…
-
Request help using INDEX MATCH
I'm trying to identify conflicting dates and locations for assets. The assets are entered into the sheet as new rows from a form. There are two columns: [Scheduled Arrival Date] and [Arrival Wet Slip]. I'm trying to use INDEX MATCH to identify when an asset's [Scheduled Arrival Date] and [Arrival Wet Slip] conflict with…
-
Reduce clicking, allow user to edit all sheet and sheet summary formulas at once
I feel like I'm clicking endlessly... 👆️👆️🖱️Double-click to open the cell formula 👆️👆️🖱️Double-click to highlight the part that I need to edit 👆️👆️🖱️Double-click to open and edit the next cell... My hand hurts. It would be great to have some sort of edit pane that allows me to edit all formulas on a sheet at once. Or…
-
can you build a formula to separate longitude and latitude after it was hyperlinked
So I have a sheet where the GPS coordinates are hyperlinked into a column with the use of a form. I would also like to have the longitude and latitude separated into their own columns for exporting to excel reasons. Is there a way to build a formula to separate the longitude and latitude that is being uploaded as a…
-
"Last 7 days" filter is different than >TODAY (-7)
Hello, I need a sanity check: Following a crazy chase for a discrepancy in my sheet, I found out that if I create a filter "In the last 7 days", it starts counting yesterday as day 1. But if I calculate SUMIF is the option {Date} > TODAY (-7), it counts today as day 1. So, my final SUMIF tally is off compared to adding the…
-
Not sure which formula I need...
I am trying to pull data from the ISIR Pull 2023-2024 sheet and make it populate the information into another range on another sheet. I want the ISIR Pull 2023-2024 sheet to match the Student ID to the Jones Scholarship sheet and pull in the FA23 HRS without having to hand-type it. (Work smarter, not harder, right?) The…
-
Same subtasks for all projects..
Hi all, I'm new here, so sorry if the question's been asked before and I couldn't find the answer, but: I work on multiple projects at once, and they typically have the same group of tasks for each (I work in communications, and for every event (/project) I draft the same suite of products, and they get approved in the…
-
Workaround for countif miscalucating unchecked boxes in column
Looking for any advice, guidance, on calculating unchecked boxes. I would like to use summary data and post to a dashboard for review and status of how many unchecked rows. However, it counts the added/unused rows at the bottom of the sheet showing an incorrect calcuating of unchecked marked boxes. We add rows to the sheet…
-
Formula to count column but exclude information within the column
I have a list of Job Classifications that is very long and I need a Countifs formula that can exclude 1 specific job class so that it can count all the others?
-
Formula to add days to a date
I have a dropdown column for PM Frequency (1 month, 3 month, 6 month etc...) and date columns for last PM and next PM. I want to add the appropriate number of days to last PM to generate a date for next PM based on the PM frequency. What is the best way to write a formula for this?