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:

Concatenate(

“Something”,

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"),

[Record_DateTime_Column]

)

if(“X”=“Y”, NUMBER("//This would be for a number column"),

HOUR([CreationDateTime])

)

In AppSheet you’ll find there’s…