Automatically populate cells based on other fields in the same row


#1

I’m using Airtable to track leads in my company.

Using a form view, my salespeople add interactions to a table. One of the first things they click on is a date field where they put the current date and time.

I would love to have a column at the end of the row titled Next Contact Date that would use a rule like =Contact Date + 15 days.

Is there any way to do that I’ve missed, or is this kind of thing on the roadmap?


#2

Ignore me I’ve solved this!

Though I have spotted something that needs fixing:

The Date Added column on the left is manually inputted, the column on the right uses the formula DATEADD({Date Added}, 10, ‘day’).

However, the column on the right is not inheriting the calendar formatting from the column on the left. (I’ve set it as European on the left column, but the formula column defaults to the U.S. style with no way to modify)

This will be very confusing, especially on days that fall between the 1st and 12th of the month.


#3

This link might help you: https://support.airtable.com/hc/en-us/articles/203255215-Formula-Field-Reference#date_and_time_functions

Have a look at the function named DATETIME_FORMAT


#4

how do i send you a private message? i need work for hire with airtable data base web site. i am at dc295@cornell.edu