Populate cells depending on the value of a column
Hello !
I am trying to find the simplest possible way (if possible) to populate some cells of a table I have. A table right below to make it understandable.
So on this table, I got three persons, that can be present or not overall. If they are, they are "by default" present Monday-Tuesday-Wednesday. If they are absent, absent "by default" on Monday-Tuesday-Wednesday.
I would like to have a button or something in lieu of the big "VALIDATE" I wrote, that would fill automatically the Monday-Tuesday-Wednesday cells depending on the "present" value for each person.
The important thing is I would like to be able to "pre-populate" the cells, and then maybe overwrite some days (like person 1 would be present by default, but exceptionnally absent on Wed, which I would adjust by hand).
Thanks for any help, if any questions are needed please ask !
[link] [comments]
Want to read more?
Check out the full article on the original site