Formula that will automatically fill in a particular data in a particular field

PLEASE I NEED HELP!!
I want a formula that will automatically fill in a particular word in a particular field


So the plan is i want to do an automation where by when there is a check box all that data goes to another table which is the re-order list, i have different table for different vendors so i find it unnecessary adding a vendors column field but the reason i added it is so when the automation takes place and the data moves to the re-order table, i will be able to identify that that product is from a particular vendor, i input the vendor name myself but i want a formula that will automatically fill in the vendor coulumn list without me inputing it manually, is it possible?

Please i really need help

Why have a table for each Vendor and a separate Reorder List table when this could all be done in one table with multiple views? Each view would be filtered by either Vendor = "x" or Re-order = true.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.