Hi, currently my team wants to have a form to submit warning for staff. A warning will last for 30 days, if staff violate within 30 days, it will automatically be their 2nd warning just by submitting formPlease help, i don't know how to set up the fi...
Morning! I'm having trouble getting Airtable to recognise the output of this formula as a date. It is basically saying "if it's in this city/country, you need to begin the project x,y or z number of months before the required by date". The last "othe...
Hi guys,I currently have the below in a grid view.I would like to have a formula in the "Timeframe Status" column which will do the following:1. Check whether text has been added to the "RFI Resolution" field.2. If the "RFI Resolution" field is not e...
Hey there.I'm trying to get the duration of an activity by calculating the difference between 2 timestamps.These timestamps are the results of a formula that shows the time as a box is checked at the start of the activity and another, at the end. The...
Hi,I have a base with a lot of records being submitted that have dates attached such as events. I want to be able to show the next 20 records coming up, keeping in mind this will change any time a new record is created with an upcoming date in the ne...
Hi guys,I have 2 columns in Grid view, each with date and time. One is a "Created" column, the other is a "Resolved" column.I am wanting to have a formula to put into a 3rd column / field to work out the business hours between the two other fields. H...
So I found a formula someone else made that does exactly what I need it to do. I need to display the dates of certain events as "week of" so I can group the event by the week and see how many posts are made during the week. The problem with the for...
I built a task management table that tracks, start, due, and completion dates.The start date is logged by an AT automation that pulls from a field called Todays Date. That field is set to PDT in the field options.The due date pulls a unique SLA from ...
Apologies in advance if this is elsewhere or common knowledge or the query is posted in the wrong location (Formulas). I did look all around to find a similar Q&A elsewhere (found some close but none exactly what I was looking for), so...TWO sample u...
I just found out that both SET_LOCALE and SET_TIMEZONE functions returns an incorrect hour, at least for Europe/Lisbon and en-gb as per the below examples:SET_TIMEZONE(NOW(), 'Europe/Lisbon')SET_LOCALE(NOW(), 'en-gb')Both these functions as returning...
