This is written in the format of DATETIMEFORMAT (Datetime, 'format specifier'), in which the format specifier can be something like 'DD-MM-YYYY,' 'YYYY/MM/DD,' 'MM.DD,' etc. The DATETIMEFORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. I have tried following the logic of the help pages, but I’m not getting something right on this and can’t work it out. Understanding the DATETIMEFORMAT function. ![]() Formula field reference Formulas vs other computed fields Formula field overview Using array functions in Airtable Updated Formula Foundations. If the ‘sub-category’ isn’t a retail one then I don’t want it to leave this new price blank… Last modified time and Last modified by fields in Airtable Updated Formula. IF(OR(+0.1)Īny other combos I try using AND statements where I have followed other similar examples on different threads, but they always come back with a formula error.īasically I have a list of wholesale and retail products each with a calculated price and for customers who only buy retail I want to add 10p to their price, but I want this to only apply to products with a retail ‘sub-category’. Airtable is a relational database so formulas are applied for the entire field (column) so that the same formula applies to every record in that field. In a spreadsheet, you can put a formula in any cell. As the name of the base indicateswe created this. This article covers how to add, subtract, multiply, and divide using the formula field in Airtable. I have tried this which returns a result for all products and not just those where the Sub-Category is “Coffee Retail Beans” or “Coffee Retail Ground”. We have created the below Formula Playground base as a space to reference and test every Airtable formula. ![]() I am trying to use an IF statement and I can’t get it to work either with an AND or an OR formula (or both)…Įssentially I have a calculated price for my products and I want to create a formula field for a selection of the products IF ‘Sub-Category = X OR Y’ then take ‘Calculated Price +0.1’ to add 10p to the calculated price. Airtable formula in seconds Explain complex (or simple) formulas with easeEnter a formula that contains a built-in function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |