My base should only be Eastern Standard Time, but it keeps defaulting to GMT. The devices I use it on are all EST. What would cause this issue? - Wendy
I need to export a grand total number from Airtable to import into our payroll software as a csv. The table is setup by an employee and that employee has a new row for each month of the year with a number in it. I know that airtable sums those co...
I send emails using Airtables automation. You can see when an email is sent from inside the automation setup. Is there a way to put a field in a table that lists the last date an email was sent to easily see email history?
Is there a date formula to calculate the 1st of the month based on a date? For example, I want to calculate 11/1/2022 for 10/15/22, 10/5,22, etc. = Wendy
Looking for help creating a formula to output one of these answers based on a person’s meeting start date and the completed date of the program.
Meeting Status field (formula):
• Done
• ToDO
• NA
• Upcoming
My fields are-
• Meeting Start Date –
• Pro...
Thanks. I should have mentioned my field is set for local time zone. It is filled in by automation and the NOW function. I created a new field to set the time zone to EST, but the time isn't pulling in correctly. It looks like it is defaulting to...
Hi, Adam. I decided to enter my data into our payroll system manually. I am retiring the base I used for this information and recreating a more organized one. Thank you for the response and help! - Wendy
Thanks. I linked a new table (table 2) to the table with the dollar amounts (table 1). When I roll up the dollar field from table 1 to the rollup field in table 2, I get a $0. I linked table 2 to table 1 using the employee number. Not sure wha...
Hi, Kamille. I need a tweak to get the NA to work. For example, an employee isn’t required to complete a program until 12/1/2022. In the November program field he needs an NA. The formula is returning a missed (but with my emojis). Here is my ...