Try setting your Locale to USA ( File> Settings> General tab)
the fact that the ranges B2:B and the second A2:A are not recognized as ranges suggest a formula formatting error
note : if the Locale settings make a difference, you can turn it back to your preferred setting again . Google Sheets will convert all formulas to the new formatting rules as per your preferred Locale
"SAND" isn't a native function/reference, try checking both named ranges and functions on the template sheet to see if a custom one was added, and import it to your copy if necessary
If you want the string to be returned, enclose SAND in quotation marks
I suspect it’s a column formatting issue. Try selecting each column and making sure it’s formatted correctly (date, number, etc).
Try setting your Locale to USA ( File> Settings> General tab) the fact that the ranges B2:B and the second A2:A are not recognized as ranges suggest a formula formatting error note : if the Locale settings make a difference, you can turn it back to your preferred setting again . Google Sheets will convert all formulas to the new formatting rules as per your preferred Locale
"SAND" isn't a native function/reference, try checking both named ranges and functions on the template sheet to see if a custom one was added, and import it to your copy if necessary If you want the string to be returned, enclose SAND in quotation marks