Personalized drop-down lists
Hi there! I’ve been trying for hours to create a auto-fill formula that will allow me to populate a list based on a few rules. Youtube tutorials seem to only talk about simple 1, 2, 3, 4 lists.
I need to make a list (column) with the values “1-2 min”, “2-3 min”, “3-4 min”, etc. up to “29-30 min”. How can I use the sequence function or drag down to populate this list without having to enter each value separately?
Another type of list would be “T01-02-2024”, “T02-02-2024”, “T03-02-2024”, where only the first number in the list changes.
Any support is greatly appreciated!!
Hi there! I’ve been trying for hours to create a auto-fill formula that will allow me to populate a list based on a few rules. Youtube tutorials seem to only talk about simple 1, 2, 3, 4 lists. I need to make a list (column) with the values “1-2 min”, “2-3 min”, “3-4 min”, etc. up to “29-30 min”. How can I use the sequence function or drag down to populate this list without having to enter each value separately? Another type of list would be “T01-02-2024”, “T02-02-2024”, “T03-02-2024”, where only the first number in the list changes. Any support is greatly appreciated!! Read More