I’m not very tech-friendly, so I’m not sure what the best way to go about this request would be - any advice is very much appreciated!
I keep all of my orders in a table - each individual birthdate is imported with each order in its own column (DOB). I would like to find a solution to automatically update a separate column (ZODIAC) with the corresponding Zodiac sign depending on the day/month of birth.
I can’t seem to make it an automation in Airtable with if/then parameters because I can’t select a date range without the Year included.
Does this make sense? Any tips?
Thanks in advance!