Just as an FYI, there ARE ways you can include comments in your formulas; it’s just a hack of a way to accomplish it.
If you’re building a series of cascading IF() statements (or if you’re using the IFS() version), you can include a condition that will never be true and include you comments there.
In the image above, you can see I’ve included a line that contains an IF() statement that will NEVER be true; this then contains my comment that reminds me what part of the algorithm I’m in.
if(true=false, “//My comment here”, “”)
Because TRUE will never be equal to FALSE, this part of the series of IF() statements is skipped.
The same can be accomplished inside a concatenate as well; for instance, the following formula:
if(1=2, “//my comments here will never be included”, “”),
" and the other thing."
…gives the following output: “Something and the other thing.”
The comment in the middle is excluded; technically it IS included, but it’s an empty space that’s added in. If I were to show this with a line, the technical output would be:
“Something| and the other thing.”
With the line ( | ) representing the empty space that was added in; but since it’s empty you don’t see it.
For numbers, decimals, etc. - you have to wrap the comment in a type forcing function in order for the formula to evaluate:
if(1=2, decimal("//For example, this formula is to calculate a price, so the text needs to be a decimal"),
[Hours] * [Employee_Ref].[Employee_Per_Hour]
if(true=false, DateTime("//This example would be for a dateTime"),
if(“X”=“Y”, NUMBER("//This would be for a number column"),
In AppSheet you’ll find there’s…