Hello Grist Team.
https://docs.getgrist.com/1TatpXtnPzF1/Contacts
Explanation:
Contacts (table) can be:
NC (normaly close) with number 1, 2
NO (normaly open) with number 3, 4
ContactGroups(table) have more than one Contact Added by refList from Contacts
Is it possible to get the value of the contact number by formula like in column ContactGroups.Need:
1. get index No for Contact position in list $Scheme
2. get Contact number in this index
3. CONCAT index+1 and Contact number
4. Create List like in $ContactGroups.B but each contact Number must have his Index+1 in $Scheme column
I apologize in advance for this possibly confusing explanation.