Welcome to the community, @Smyth_County! :grinning_face_with_big_eyes: Yes, a script can do all of that, and a ton more. Scripts have fewer restrictions that formulas. Are you looking for help developing a script, or do you want to learn how to do it yourself?
A great place to start with Airtable’s scripting setup is its own docs, which you can find at the bottom of the Scripting app window, or here:
The app has several example scripts that are fairly well documented, and which you can insert into the app quickly for interactive testing.
If you run into any issues with your scripts, feel free to post here for help!