I have a column with the type formula and it populates the date, but when I try to filter that date it treats it as a text, is there a way to treat that date as a date when filtering? meaning that I can filter by today or filter by date within a cert...
If I am on a pro plan and I shared my table with someone not on a pro plan, will they be able to see/edit past the 1500 record?? also if I am on a certain view will they have their separate view since I am on a pro plan and they are not?
I think some tables requires that the new records are on the 1st row not the last, I know there are sorting options that could do that but I would like to see that as an option (top to bottom or bottom to top)
Alexandra_Durbin:
You probably cant do it in the same cell but you can do it with a formula, ive made an example for you
Airtable
Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but...
Airtable
Airtable: Organize anything you can imagine
Airtable works like a spreadsheet but gives you the power of a database to organize anything. Sign up for free.
I hope this helps
Ali_Aboutera:
IF({Days Remaining}=0,
“1- Today”,
IF({Days Remaining}=1,
“2- Tomorrow”,
IF({Days Remaining}<0,
“4- Past Meeting”,
“3- Future Meeting”)))
I’ve created a new table as an example here:
https://airtable.com/invite/l?inviteId=inv9rF3...
I did a base that has 3 fields:
1- Meeting Date (Date)
2- Days Remaining (formula)
3- Status (formula)
This is the formula for Days Remaining:
DATETIME_DIFF({Meeting Date}, TODAY(), ‘days’)
This is the formula for Status:
IF({Days Remaining}=0,
“1- T...
