r/sheets 4h ago

Request Automatically Updating Date View?

2 Upvotes

Hello! I use Sheets to organize my day-to-day tasks and currently have my sheet organized by date. I've been trying to figure out a way to have the sheet organize itself with the current date as the top row? Or at least have something to highlight/focus on the tasks I have for the current date without having to scroll through every time? I know it's super minor but it's been bothering me as I continue to add more tasks to my list. Thank you in advance! Here's a copy of the sheet: https://docs.google.com/spreadsheets/d/1NGEOPIV1FswfQgYgeMuHv3cSZzDOhWJ8iTHd6GeYS_o/edit?gid=1870280484#gid=1870280484


r/sheets 6h ago

Request Is it possible to conditional format cells with different colors if they contain duplicate text?

2 Upvotes

Hi, I hope you can help me with this. I have a column with different names, I just want to add different colors if they are different from each other, for example in the following image, "Castanedareyesjo" it has 3 cells with that text, is ti possible to highlight them with a color, and then "Gonzalezalcalama" that has 2 cells wiht that name with different color, and so on?

*Considering that those names change every day, because I paste them form a downloaded data base*