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…
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 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 ne…
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…
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 calcula…
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 th…
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…
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 adde…
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?
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 ne…