That could potentially work in some situations, and certainly I am on a learning curve to figure out what tools to use and when to use them in effective data management.
The problem with your suggested alternatives for my purposes is that some of the “attributes” I envisaged tagging have more than 20 possible values, which, in my understanding, kind of negates the use of status or dropdown, since they have a maximum ~20 possible unique indexes.
I have been working on using tags in the following columns:
client code (a three-number code identifying the client with whom the item is associated). Currently we’re only using Monday.com for work associated with ~5, so status column would work (and I’m using it), but if we integrate our workflows for all of our work, a limit of 20 options will not work.
File type (the three to four letter file extension for the output type of a deliverable associated with the task - this could likely work with a dropdown for the foreseeable future)
Infrastructure name (the many-character name of the infrastructure ID associated with the task, with individual words connected with underscores to make it compatible with tag data type. This is the one in particular where there are actually probably closer to 100 options it could be, and so neither a status or drop down is compatible. I also sometimes have more than one infrastructure name associated with a single item, so a status column wouldn’t work. A dropdown menu could work, if there was not a limit on the number of possible values for the column)
Business Unit (the client acronym for the associated sector for which a project is being used. There could be multiple sectors represented by a single project, meaning a status column would not work, because I need to use more than one for a single item, sometimes. Again, depending on scalability to all of our clients, having a limit of unique values/indexes could create a problem in the future)
Like I say, my learning curve is steep as I weigh the pros and cons of each column type and try to think of the best way to aggregate, parse, granulate, summarize, track, sort, etc., etc. our data…
One of your suggestions involves using dropdowns instead of tags. I didn’t think dropdown menus were importable from excel, either (?). How would you import multiple values for a single row/item?
Thank you, Talia.
Measurement Sciences Inc.
Cell: +1(587) 298-6545