Get Rid of that Red Line
Learn how to eliminate the red line error in Google Sheets when using custom functions created in Apps Script. This video guides you through the simple steps to ensure your function is recognized as a native formula.
You've created a function inside of Apps Script and you're trying to use that function in a cell and you're getting a red line and you're getting this unknown function . But when you hit enter, the function actually runs. It totally is fine. Here's how to get rid of that red line. Your function is not wrong. Your function is just missing something. What we want to do above the function is add a comment which is slash asterix. Hit enter and write at custom function. Now, if we save it. Go back to our sheet and we do equals adjusted score, it shows up just like a native function inside of Google Sheets. This is just like SUM works exactly the same way. How to Write a Function - Learn to Code in Google Sheets Part 2 Getting Started Coding in Apps Script Add Custom Function Ability to any Google Sheets Function Create Custom Functions in Google Sheets