In google appsheet, i am creating parent data entry form “table1” and child data form “table2”. i want to create rule for date column in “table2” bases on condition of column name “Column1” in “table1”, if “TypeA” and “TypeB” is selected in “Column1” of “table1”, the date column in “table2” have to enter for every entry and if “TypeB” is selected in “Column1” of “table1”, date in “table2” have to select one time and no need to select again every for every entry, only one date will fill down to every entry. how can i create that type of rule. is it possible?
1 Like
You can get the value of Column1 in Table1 with the expression [ref col table1].[column1]
In the valid-if of the date column in Table2, construct an expression using IFS().
3 Likes
Thanks for your answer, I have made temporary workaround by adding new column and return value with IF(ISNOTBLANK) function.