Lookup formula or anything similar

[alhazen]

Hello guys

I have two tables which are "schedule" and "assessment".   in table "schedule" there are two columns namely [id], [start date] and one virtual column with list type [related assessments]. In table "assessment" there are three columns namely [id], [schedule], [entry_date]. [schedule] is ref type column from  "schedule" table. 

i would to know how, when user input date manually on [entry_date] column, [start date] column will autofill with [entry_date] value. Thank you very much for your help.

cc: @Steve 

[TeeSee1 · Accepted solution]

LOOKUP does not work because your schedule has many related assessment rows and cannot identify which row's [entry_date] to use.

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Using-INPUT-to-update-another-table-using-a-valu...

should give you what you need to do.

With this approach, whenever a user enters [entry_date] in assessment table then the very last entry will overwrite [start date] in schedule.

[alhazen]

thank you sir