<aside> 💡 You can use the Clay Formula column to apply simple (or complex!) formulas to your data in Clay. We'll be adding more suggestions shortly but let us know if we can help with any.
</aside>
When you go to add a new column, you can find the formula column at the end of the Add Column list. When you choose Formula, the setup column will pop up ✨
Fields → Below the formula box, you'll see a list of all of the columns in your table (and data from your actions that hasn't been extracted!) Clicking on any of these inserts them into your formula with proper formatting.Preview Box→ See how your data is transformed once your formula has run in the preview before the input box.
Operators → Simple calculations you can run e.g. a + b
Function → More complex formulas you can run for a column. Work with pre-defined functions from Excel or ****add a bit of custom code directly into your table.Primitives → Work with a variety of data types.
5, 42, -1, 3.14, etc."foo", 'Clay', they need to be in " or 'true, false[ "do", "ray", "me" ]We've aggregated a few common formula examples and how to write them here 👇