6 - Interface Innovator
since ‎May 12, 2020
‎Nov 29, 2022

## User Statistics

• 18 Posts
• 1 Solutions
• 3 Kudos given

## How to write an IF AND formula

I’m trying to create a formula where if two records are true it prints an answer. Here’s my formula: IF(AND({Role}= “Free”),{# Plans} => 5),“Cannot Add Plans”). I want it to show Cannot Add Plans if the Role = Free and the # of Plans => 5. It’s no...

## Multilevel Pivot Table Functionality

I love Airtable’s ability to create views and then sorting, filtering, and grouping to see things like average, median, range, etc. I am using Airtable for a pricing database across multiple vendors (basically, see how much vendors are charging othe...

## Creating Rating/Scoring System vs. Average Fee

Looking for help creating a formula that can determine how good a certain price is compared to an average price calculated in Airtable. For example, let’s say the average price of something in a record is \$100. If my price is within 5% (+/-) of \$10...

## Converting Percentage

I have a Rollup field that takes a series of decimal percentages from another table (e.g .68%, .72%, and .55%) and then calculates the average (.65%). I have the formatting of this field as Percentage and precision of 1.00. Unfortunately, when Ai...

## Formula for Currency - Rounding

I found the following formula I am using to format currency. I want to round up or down and get rid of the decimals . Any ideas on how to modify the formula to do that? Thanks! IF( LEFT({NumberValue}&’’,1,1)=’-’, ‘-’, ‘’)&’\$’& IF( ABS(VALUE({Numbe...
Kudos from
Kudos given to