Does anyone have knowledge if the roll out of Table View is causing syntax issues with the SS formula operators, or anything for that matter? I've been using one thread for the last two years, I went to update it today, and I keep getting Incorrect Argument Error and Unparsable errors.
Below is the formula that has been working perfectly until today. I went to update the references to 2027 and now it eats itself. I also tried to back into the script to see if I could find where the error occurred, and it is occurring right after the FIRST reference range. "Last Name, First Name" in the thread below just represents my co-workers…I didn't want to put their names out into the "cyberverse."
Does anyone know if the "new formula editor" they rolled out is what I need to use now?
Any input would be helpful.
=COUNTIFS({2026 Budget Tracking Range 1}, OR(@cell = "Owned", @cell = "Partially Owned"), {2026 Budget Tracking Range 3}, ("In Progress"), {2026 Budget Tracking Range 2}, OR(@cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name", @cell = "Last Name, First Name"))
