Hello,So currently, we do have a tick box on this view and manually tick it once it is the latest valuation.Do you have any ideas on how can I automate this? without doing the manual ticking?Another issue, I created this formula : IF({latestVal Date}...
I am trying to generate sales goals in a formula, I have a column with the previous years result (manually entered), I have a % column with my growth target but I cannot figure out how to create a column with a formula that takes the previous result ...
Hello!I am creating a list of tasks that need due dates assigned using the following conditions:1. Each task is due one day after the previous task is due (note: dependencies would be nice to have but not necessary)2. The tasks are never due on Frida...
I hope this is the right place for this question, but we'll see!Context: We have a 'Tasks' table where each team member may have a list of hundreds of tasks (thanks to the joys of generating task templates). I would like to have a View for users that...
Hmm, I feel like this should be easier, but I'm running into a stumbling block.I have a Multiple Select column {Dubbing VO (all languages)} that has a list of VO actors. Each name begins with the two letter code for what language they are working in....
I am trying to create a tracker for trip expenses. I have a list of Attendees in one table, then Receipts in another with a "Charge To" field (since sometimes expenses wont be shared evenly across the group) that is a link to the Attendees table. Wha...
I have two fieldsa start day for a task (date field)an estimated number of workdays the work will take to complete (a number).I want to add those workdays to the start date and count ahead to the date the work will be completed. I do not want to coun...
Hi Everyone!I'm looking for some help editing this script from the marketplace.Right now, I can select 2 fields for the duplicate comparison but I actually need 3. How can I change this to have it compare 3 fields instead of 2?Also, this script has t...
I have a table named Licenses with a Current? field [Yes|No]. The table is linked to the Employees table by the Employee # field. For each Employee, there could be a License record with:zero or many rows where Current? is Nozero or one row where Cur...
Hello,I am working on a property management system and there are contracts in two currencies. For all the data to make sense I need to convert the dllr contracts information to pesos with the current exchange rate. In the table where I have inflation...
Hello Airtable Community,I have 2 tables: Attendance and Performances. People will fill out my ticket request form, submitting their preferred number of tickets for Performance Dates 1,2,3 etc. This gets recorded in the Attendance table under their ...
I am struggling to get the DATETIME_FORMAT to return the correct time for me. For example, my Start Date is 10 January 2023 00:00 and in my formula column, I just want it to extract the time of the "Start Date". So I put in this formula: DATETIME_FOR...
My table is for students in a tutoring program. One field is their current grade. Another is the calculated formula of today's date. Every August 15th (each year) I want each student's current grade to increase by 1. Is there a way to do this?
hello, I'm trying to make a table where employees upload two dates through a form, when they go on vacation and when they return.So far so good, I was able to make a formula that counts the weekdays and these are subtracted from the number of availab...
I will preface with saying I have a hard time with functions. Not my brain thing. So, as much as I have searched for solutions I suspect my search terms weren't correct enough to find the answer. So I am hoping someone here can help.I need my email c...
Good Day,We added a CSV file with all our invoice amounts, and we have also added a CSV with all our credit notes.Is there a formula that will automatically deduct the credit note amount from the invoice amount based on the Document Type column?So I ...
Hello Airtable friends.I have a somewhat simple formulaic excel sheet that becomes very complicated when breaking it up to be used in Airtable.The goal:Based on the type of sale, each of 6 static 'sale stages' should have defaul percentage (out of 10...
Hi,I'm trying to validate customer's mails, to send them automated mails.I created a column validating another Email column in my relevant table, but the formula shows me that the mail doesn't match the regex, even though I know it's a working mail.t...
Hi all, I figured out an easy workaround, but trying to understand why this is happening.I have three table that matter to this scenario - Employee, Certificate, and EmployeeCertificate (junction table)The Certificate table has a number field {Period...
Hi expert guys and gals, I am struggling with what appears to be a straightforward mundane issue, but I have scoured the Community and the internet without any luck. I have workers schedules and sometimes they work Monday to Friday, but sometimes the...
| User | Count |
|---|---|
| 785 | |
| 756 | |
| 581 | |
| 470 | |
| 273 |
