Because Airtable’s data structure is more akin to a database than a spreadsheet, cells can’t directly reference other cells. There are ways to work around this, but they’re complex. If you’d like to read more, this is the thread you want:

Thanks a lot!!!, thats wt I need.