Help
Other questions
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

TODAY() reports wrong date

Sheet here: (can’t post due to new user) Column 1 is “Date” type with the time field disabled. Column 2 is “Formula” type: IF({Due Date} != "", {Due Date}, TODAY()) On row 2, if {Due Date} is empty, it automatically fills today’s date, ie, November 5...

Add multiple records into one field/entry?

Greetings! I am trying to figure out the best way to add dates/times of different candidates spoken to for interviews. Ideally, I would like to have one project line entered and then be able to click on the project to see which candidates were interv...

Amanda13 by 4 - Data Explorer
  • 618 Views
  • 3 replies
  • 1 kudos

Timezone not working correctly

I'm currently in Seoul, South Korea. I'm working with a partner based in NYC. I'm looking to set the timezone of specific fields to EDT as this team needs to automate workflows for the upcoming [tomorrow]'s day's work. I failed to post this last nigh...

cowboyjim by 4 - Data Explorer
  • 426 Views
  • 1 replies
  • 0 kudos

Resolved! Created date time field and imported data

I have built an Airtable structure that utilizes the Created date/time field type to track when a record is added. This Airtable solution will replace an Excel version of the same data. The Excel version contains 2 years worth of data with it’s own c...

Scott_Callery by 6 - Interface Innovator
Solved
  • 3888 Views
  • 4 replies
  • 6 kudos

Print A3 Year Calendar

I have a company planner in airtable that I want to print in a year view colour coded with the project name printed.  How do I do that?  It doesn't have a year view option so I added the calendar to my google calendar but year view in that doesn't wo...

patch by 4 - Data Explorer
  • 307 Views
  • 0 replies
  • 1 kudos

Resolved! Add or subtract years in a date

I have a date in CurDt and I want to add YrOffset to it and end up with a new date in a date format. YrOffset can be negative, positive or 0. I’m not sure how to do it.

Timestamp for when checkbox has been checked

I’m working on a trouble ticket table that keeps track of support for our users. I want to be able to track when a box was checked. So I have a “Followed up” checkbox field and I’d like to track the time from when the record was created to when the b...