Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Airtable Community
- Discussions
- Ask A Question
- Formulas
- Is it possible to make comments within a formula?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Topic Labels:
Formulas

4
7522
16

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Comment Post Options

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Feb 28, 2020 11:48 AM

Can you make a single line comments within a formula?

Reply

16 Replies 16

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Feb 28, 2020 12:47 PM

No, you cannot make comments in a formula field.

If you have a particularly complex formula that you might need to adjust later, you should probably document it elsewhere.

If the formula is a calculation based on inputted values that will never change, consider shifting the logic to the Scripting block. You can include comments in the JavaScript. One disadvantage is that you will still have to manually run the Scripting block.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 04, 2020 07:26 AM

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

May 04, 2020 07:38 AM

Would love this! Please add to the Product Suggestions topic!

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Oct 24, 2020 12:42 AM

This would really be a useful addition to make complex formulas easier to understand.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 03, 2021 05:26 PM

Was just going to search for answer how to do this and this post came out on top search results. Right on. Yes exactly this is what we need.

I have many fields with massive formulas, about 1-2 letter size pages printed in regular font and I can’t break them down because I am running out of fields in Airtable (500 fields limit). So now I am getting headache of the super long formulas.

Being able to put comments like ** THIS IS A COMMENT ** or /// THIS IS A COMMENT \\ would be fantastic.

(I can’t put the formulas in scripts, first I have no idea about programming and secondly the formulas use 100’s of fields in the table so values constantly change)

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 03, 2021 09:39 PM

While you still cannot make an official comment in a formula, I use this workaround to comment more complex formulas:

For example, if my formula is …

```
{lookup field} & ""
```

I can comment it like this …

```
IF(
"convert lookup value to a string",
{lookup field} & ""
)
```

I also use this technique to document “magic numbers” in formulas:

```
IF(
"circumference = 2 * radius * pi, where pi is 3.14",
2 * {radius} * 3.14
)
```

This workaround takes advantage of the fact that the string will always evaluate as true. When properly used, this technique also does not affect the resulting data type of the formula.

Keep in mind that this technique adds extra calculation time to the formula, which may already take a long time to calculate. If the formula is approaching the undocumented formula limits, you may also need to take care in adding branches to the formula just for the sake of comments.

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 05, 2021 10:35 AM

Interesting, this will definitively help to add comments to remind myself what is the purpose of things in the formula. Now I actually realize I could add some dummy formulas to that like…

IF ( “…this is some comment for the next section in the formula …”,0,0)

… if it is surrounded by + or - signs

or

IF ( “…this is some comment for the next section in the formula …”,1,1)

… if it is surrounded by * or / signs

Great. At least something.

Also - I need to get used to use spaces in Airtable. I am used to use formulas in Excel and there are no spaces allowed so old habits never die and always keep working without spaces out of fear something will break some day if I have spaces in Airtable. Are spaces completely safe?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 05, 2021 10:58 AM

White space (spaces, new lines, etc.) are safe *between* elements in a formula. For example, between a field name and an operator.

White space is not allowed between a function name and the opening parenthesis. For example, this is not valid:

`IF ( "This is not allowed", 1, 1)`

Reply

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Jul 05, 2021 03:56 PM