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...
I'm using a simple formula to calculate the due date difference between today and the project due date:WORKDAY_DIFF(TODAY(), {Due Date})-1Which works for anything due today and in the future, but does not calculate properly for past due things. If to...
Hi all,I want to prioritise datasets in Airtable. For that I've created checkbox fields and a drop down field.I now want to create a formular field and add there a weighted text drop down menu by giving each text option a number. For the checkbox fie...
Can you help me with a formula to remove all characters including and after the "(" in Los Angeles (hollywood)?So my goal is to make Los Angeles (hollywood) --> Los Angeles
How do I write a formula to populate anything that is created in that week, it will add the Monday date of that week. For Example:I have records for 10/7, 10/8, 10/10. I need the Starting Week of to be: 10/7 for all Dates. Then I need records for 10/...
I've been scouring this forum for an answer to a variant of "Convert String to Duration" but alas, no simple answers uncovered!In my case, I have a text field that contains duration as as string such as, "1:30:00."I need this to now be a field that i...
I have a weird one: How would I even begin to convert a column that contains duration data formatted as a string like this? I want the final conversion to be a decimal number, but none of the standard DATETIME() type formulas can make sense of it. He...
| User | Count |
|---|---|
| 900 | |
| 835 | |
| 610 | |
| 547 | |
| 361 |
