Feature Requests

I would like to be able to drag the bottom right corner of the Advanced Editor modal and resize it to see the entire formula without having to scroll. Currently when working with more complex formulas it's a decision between creating the formula in another window so I can see everything (Notepad++ for example) or not being able to see everything, but having the real-time validation. This enhancement would fix the need for that decision.

Ability to include Formula fields in Rollups/Lookups is essential, instead of having to create another formula field.

The formula field was enhanced to support returning numeric values for Time Tracking Log and Duration fields, allowing Solution Managers to configure formulas that evaluate the numeric time value of the fields. This feature can be used to aggregate time values across multiple linked records, or to perform other calculations such as multiplying hours by a rate to determine a final price. These fields have granularity at the second level, so referencing them in a formula will return the number of seconds for the Time Tracking or Duration field. To derive hours, simply divide the returned value by 3600 (the number of seconds in an hour. For example: ROUND([Time Tracking Log]/3600,2) will return 1.50 if the value of the field is 1h 30m.

Ability to use a Time Log field type in a formula so we can calculate Budget versus Actual.

Would love to be able to use a formula to shorten certain elements for the title of a record. For example, if I want to concatenate the type of meeting and the date only from a date|time field, I want only a certain part of the date (this would have to be used in conjunction with an ISO display format) : LEFT(date field, 10)

Similar to other development tools, I would like the ability to add comments to the formula so that more complex formulas can be more easily read and edited later.

A command to do more generally what we currently need AVGIF, SUMIF and COUNTIF to do. Select records that meet some criteria and returns a list of those records. Syntax: SELECTIF( Criteria, [Linked Record Field] ) This would make it possible to do much more general calculations involving summaries of records, like calculating the standard deviation of a set of records with a certain status.

Ceiling (6.11) = 7 Floor (6.11) = 6 Airtable has these.

I would like to be able to use the lookup field in formulas.

Please provide a function to retrieve a value from the most recent linked record (or last linked record). The format would be something like MOSTRECENTVALUE([Date field to evaluate], [Field to Display]) This would allow you to: Retrieve the status of the most recent linked record and display in the parent record. Do trending by comparing a current value to a value in the most recent record. Retrieve the most recent result from a series of linked metrics. Etc!