Hi everyone,I am wondering if there is a workaround/solution without using make.com or scripting.I have data in one column for example. The column is a linked field.Items | Qty_to_BuyA|5A|1B|1B|1B|6C|10 I want to create a table with the following out...
I am using a DATETIME_FORMAT formula to reformat a Date input field and make it pretty. For some reason no matter what time I put in to the Date input field the formula field spits out a time exactly four hours later. Anyone know why this is happenin...
Hi.I have two Date files with Time Called Start and Ende.g.:Start=08.05.2024 09:54End= 08.05.2024 12:00in another filed I'd like to calculate this into hours rounded to full 15 minutes using:IF( AND({End}, {Start}),ROUND(DATETIME_DIFF({End}, {Start},...
I want to create a formula fields equal to now() with specific hours and minutes. My formula must return a date equals to today at 18:00. Exemple today is 05/06/2024 16:12 -> 05/06/2024 18:00Thanks
Hello-I have a lookup cell that is pulling data from multiple cells. The results are showing a list of topics. The topics are repeated (as they're pulling from different cells). You can see, for example, that "Space" is being pulled multiple times. I...
Hi, is there an option to stop the Formula Helper dialogue box appearing when I click in the Formula edit box?The thing obstructs visibility of the formula when I'm trying to edit. I'm having to click out of the formula edit field to close the dial...
Hi, we track which topics will be posted to social media mainly in calendar view in Airtable. Ex. Have "receipe" show up every Wednesday on the calendar instead of having to input the date manually. Any suggestion on how to accomplish that?
Hi there— Grateful for your help in figuring this out.I have a single select dropdown field in one cell. If a user selects an option in that dropdown field, I'd like the cell next to it to replace the text based on whatever is selected. So in the scr...
I want to have a select field with a couple of options for clients that need a subscription. Like: "1 month subscription", "2 month subscription", ... . This would ideally convert the answer into a 31 day duration field that can then be used in a dat...
Hi! I'm having trouble with a formula where it brings back text and adds " " when it is done. Here is the layout:Column 1: Formula cell with the following formula {Client} & ' - ' & {Total Volume}Column 2: Linked to another table, displays {Client} n...
| User | Count |
|---|---|
| 857 | |
| 823 | |
| 601 | |
| 517 | |
| 303 |
