If you’re using a custom action on form submit, then you can do this quite easily with an Add Row action. One of the options with this action is to specify a custom value for any column. You can use this to set the status of the new row.
I guess just to add to that - and getting back to the topic of formulas in the Google Sheet vs calculated columns in Glide - as a general rule I try to avoid spreadsheet formulas as much as I can. This is because if you can do calculations in Glide, then your app will be much snappier. There are times when spreadsheet formulas (or scripts) are the only answer, but the Glide data editor is quite powerful, and with a little bit of imagination and creativity you’ll find that most things are possible.