Autofill cells when new line is created
I'm trying to figure out if, when a new line is getting filled out on my SS, can a workflow be created that will autofill a certain cell within that row to a particular choice within that dropdown list? In other words, someone enters a new row and starts filling out the required info. As soon as that info is starting to be filled out, I'd like that "Status" cell to show "Pending" right away. As certain things get filled out, we can change the "Status" to other choices in the drop down.
Help Article Resources
Check out the Formula Handbook template!