I was wondering if there a way to set REQUIRED flag for a ONE OF several columns in a group. Say I have a table where users provide their weather observations.
There is a set of columns for air, visibility, sea state and ice (if any). Each of these group includes 5-6 columns and I would like to have only ONE OF the column in each group to be mandatory. So, ANY ONE of AIR group, ANY ONE of VISIBILITY group, ANY ONE of SEA STATE etc.
That i, a user cannot leave the entire AIR group blank (set blank by default); at least one observation must be provided.
In GAS I could have achieved this via App Script, however, could not so far find a tool here.
Would appreciate a hint on this.