I would like an automation that leverages custom fields to dynamically populate the Item field. For example, controllable fields such as Course (dropdown), Materials (dropdown), and Submitter (email) can be combined via automation into a structured naming convention for the Item field, such as “Course-Material-Submitter”.
I’ve built this logic using a formula column, but I face three limitations:
- I cannot overwrite the Item field with the formula output.
- I cannot hide the Item column.
- I cannot move the formula column to the first position on the left.
Any of these three solutions would help, but ideally, I would like the ability to overwrite the Item field using a controlled formula-driven approach.