Hi everyone,I desperately need help as this formula is driving me crazy! Basically the formula works except for Jan - Feb and March 25 and shows them as Q2 24 instead of Q$ 24. This is the fiscal breakdownQ1: april24,may24, juen24 -> Fiscal year (e....
Hey Gang.I know there's probably multiple ways to do this but I'll ask.If there's an automation way of stripping/grabbing two(as there will always be two) linked records in a field and placing the first in the "first instructor) field(email type), an...
First post, so I am sorry if this is not clear as to what I am trying to do. My goal is to have a formula in a field determine if 3 different fields are either blank or not blank. Depending on whether they are blank or not return a message to that ...
Hi there, I'm trying to bring a value from a previous row into another row, matching on two conditions.For context, I am ultimately trying to compare the difference in revenue between two rows, submitted by the same company, in adjacent quarters.Does...
Hi there, I am trying to calculate employee hours worked over 40 within the span of a worked week (Sunday - Saturday) for overtime calculations, and can't figure out what the formula would be for this. I have start dates and times on my sheet already...
Very new to Airtable and having some fun with formulas.I have project records with a simple status field (Planned, In Progress, Completed) and some basic date fields.I created a formula that checks if the project is "On time" or "Overdue" based on th...
Hi guys....I have two columns "Old Price" and "New Price".I want to achieve something like this:When "New Price" updates, then the previous "New Price" before the update becomes the "Old Price".Here (below) is how the code I want to achieve look like...
I am trying to come up with a calculation of the parts I need to batch-produce a product.I currently Have tables for: Products, Product Variations, Parts, and Production Plan.For example, If I need to make the product "Tea Light", this comes in small...
I am new to airtable. I used this Standard Deviation STDEV - Quick Reference - Airtable Community to calculated the standard deviation. However I have 5 fields in this table and sometimes only 3 or 4 values are entered. I would like to only consider...
I am wondering what Record comments can be used for. It looks like Record comments aren't accessible by formulas, automations interfaces, etc. That is, I can't create a formula that tells me if there are comments, that returns, the comments, etc. I c...
| User | Count |
|---|---|
| 906 | |
| 837 | |
| 611 | |
| 552 | |
| 385 |
