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...
HiI am a newbie on airtable and want to start with my personal finance overview.The csv. export of my bank statement will be used to feed the base. From this I want to put each transaction into categories (to see budgets etc.). Is there a way in airt...
Hoping there is maybe native support here now, but probably not.I have a table where all the records are parts, and they have part ID, unit weight, quantity, and total weight. I would like to add a field that shows what % of the total weight of ALL p...
Hi,I want to have in one column the data from the remaining selected text, lookup and line items, fields which will be formatted in html. I managed to partially achieve the desired effect, by using the formula type But unfortunately data is not prese...
Hi,I'm trying to figure out if there is a script or formula to allow for when cells are updated in a column of a Google Sheet to update a corresponding column in Airtable. Here's the scenario I have:I have a Google Sheet that is organized by client p...
Hello,I am currently running into the base exceeding automation limit and am trying to come up with a way to solve for multiple automations we have created by using a formula field or look up field.Currently, we assign users to certain tasks and we h...
| User | Count |
|---|---|
| 900 | |
| 835 | |
| 610 | |
| 547 | |
| 363 |
