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...
Bonjour,J'ai dans ma base un champ de recherche qui me permet de récupérer les dates de différents enregistrements liés. Parmi toutes les dates remontées, je souhaite définir quelle est la plus petite (ou la plus grande) : comment faire ?Merci pour v...
| User | Count |
|---|---|
| 900 | |
| 835 | |
| 610 | |
| 547 | |
| 366 |
