I'm tracking book publications and each of the titles in my database will have several dates for different formats - Hardback, paperback, ebook and Audio...I'm trying to create a formula that will automatically select the earliest of these dates so t...
I have an airtable that has the following data: [ { "id": 46, "createdTime": "2024-11-22T06:48:11.000Z", "Campaign": [ "rec1OnuA36COKk2rC" ], "Status": "Posted", "Account": [ "recFO8uEMB7wZaSYw" ], "Exter...
Hello. I'm trying to create an IF formula that returns some text if the date field is a specific date. Each date would need its own specific text.e.g. If my date field was 05/01/2025, then the IF formula field would return specfic text (e.g Day 1).Th...
I know there has to be a solution for this, but I just haven't found it - trying myself.Pretty Simple I'm trying to make a simple purchase/expense tracking table for the different program team since we're an NPO and have to account for what is spent ...
We're a publishing company and we keep track of content that we publish over the course of the year with these different columns showing publish dates. I'd like to do 2 things:Create 1 column that combines the dates (combining them so that they remai...
Hello everyone,Newbie here! I'm trying to create a base that can track all the annual membership payments and also send them an automatic email 2 weeks before the renewal date (based on the MEMBERSHIP JOINING DATE) is due, plus two more reminder emai...
Revenue = Quantity * Price7496.90 = 150 * 49.98Why is the number rounding up to 7497.00????Another Example: $205.80 = 25 * $8.23The value I get in my Revenue Cell is rounded down to $205.75.Here is the revenue formula vs. what it should be. The numbe...
I'm trying to score based on a percentage another field is calculating.If Profitability is greater than 0%, score 2.If Profitability is between -5% and 0%, score 1.If Profitability is less than -5%, score 0.I can get it to work for greater than 0% an...
We are a publishing company and we publish individual pieces of content on multiple dates. I have a different sheet that I'd like to have all of those dates be put together into 1 cell (see attached). Is there a way to do that so that if I fill in a...
Hi I have two fields ie a created time field and a formula field for the time field. I have an issue with time displayed in the formula field. It seems to convert the time I don't know why,, here is the formula: IF( {Posting Date} > NOW(), "Posted: T...
| User | Count |
|---|---|
| 900 | |
| 835 | |
| 610 | |
| 547 | |
| 366 |
