Forum Discussion
Convert from Google Sheets using IFERROR not working
mtarler jenniferk007 I can't replicate the error on a Mac. As far as I can see there nothing special about any of the formulas in this tread that would cause an error on a Mac. All of the functions are supported in that version if I recall correctly. The only thing I can think of is that you get the message box line in the picture below.
As you know, this shows up on a PC as well if you are using the wrong list separator, for instance. If that's not it, can you jenniferk007 upload a screenshot showing us what exactly is going on. Even better if you could upload or share the file.
I have a list of standards on 1. Outlining the Course. On the Action Plan tab, I just want to list all the standards not met when an "x" is entered into the Change Request column.
Here is the Excel file, exported from Google Sheets.
jenniferk007 In the attached I used this formula:
=LET(ls,FILTER(CourseTable,CourseTable[Change Request]="x",""), INDEX(ls,ROWS(ls),{1,3,4,10,11}))I formatted the data on the first tab as a table so the references can be cleaner (i.e. instead of a reference like '1. Outlining the Course'!$A$2:$K$100 which would be an issue if you exceeded line 100 later on or using '1. Outlining the Course'!$A:$K which could slow down the worksheet while it checks thousands of unused rows I use the reference CourseTable instead (the name I gave the table on the other tab).
but note that any formula will not pull the hyperlink or any other formatting over to the other sheet
it will also dynamically update if/when you change the "x" on the other sheet so that extra column for completion status WILL get out of synch if/when you add/remove "x"s from the other tab.
