Hey I'm quite new but couldn't find an answer : I'm looking to show the average of a column in the interface. To be specific, I have a set of data from one table and I'm selecting certain data from another table, and I want to calculate the average o...
Hello,I'm moving into the List View Interface, and I am loving the "Prefix" field which allows me to use visual indicators to quickly see the status of records. My current roadblock is this, I haven't been able to figure out:How can I have a Single S...
I am trying to create a project tracker with a task list and start dates and end dates for each task that are calculated automatically based on a dependent (linked) task and its associated dates. My problem is how to create the first row because no m...
Hello,Using a last modified field type named "Closed" and a lookup field showing the last one called "Meter Type" and "Repeat Interval" I am trying to calculate and output the appropriate date when closed is 7/17/2024 16:41, meter type is Calendar Mo...
Hi Just wondering if anybody can help with a formula?I'm trying to set up a task (meeting date) that can occur on a Tuesday of say the 1st week, 2nd week, 3rd week or 4th week of the month. So lets say the due day was Tuesday 02/10/2024 then i'd lik...
I have master blocks of code in my code table.in another table - main table -I wish to get data from a field in the code table by specifying it’s rec ID. I will then combine this code with other data from the main table. I can do this with a linked t...
I have been reading for hours through the help forum and documentation, but ARRAYSLICE doesn't want to work for me.I want to achieve the following: Show me the first value of an array. My formula is: ARRAYSLICE(verticals_from_contact, 1, 1) but it do...
New to all of this. No coding background; small business owner. I am trying to create a rudimentary inventory system with Airtable. I can't figure out how to get a formula to "count" the number of array entries in a linked record field, and return ba...
I have four (4) columns that are number data fields titled {Trip 1 Miles}, {Trip 2 Miles}, {Trip 3 Miles}, and {Trip 4 Miles}. The settings to the number data fields include decimal places and a screenshot of the settings are attached.Column five (5)...
I working on a formula that will provide me with 4 different outcomes depending on a products Variance from our target cost of product/FOB. Any products that have a variance less than -5% need to output "Red -5% or More Variance", products with a var...
| User | Count |
|---|---|
| 893 | |
| 833 | |
| 609 | |
| 530 | |
| 351 |
