Populate cells depending on the value of a column

Our take

Are you looking for a straightforward way to automate cell population in your spreadsheet based on the presence of individuals? In your table, you want to set default attendance for three people across Monday to Wednesday, where they are typically marked present unless specified otherwise. By implementing a button to automatically fill these cells according to their attendance status, you can streamline your workflow. This solution will allow for easy adjustments, enabling you to override default settings for specific days as needed.

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.

https://preview.redd.it/lynysfdnk6zg1.png?width=351&format=png&auto=webp&s=e7d6f65e5831cc8bedcfb354eedb22d3f7de0532

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 !

submitted by /u/EaraNiniel
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#rows.com#big data management in spreadsheets#Excel compatibility#big data performance#Excel alternatives#populate#cells#table#present#persons#absent#Monday#Tuesday#Wednesday#default#button#pre-populate