I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once that is selected I want smartsheet to auto-fill the rest of the questions or cells in with the specification or drawings number, and who is responsible, for submitting this, etc.
I am trying to create a dummy proof system to keep everything organized and in-check. Let me know how and if this can be done.
Thank you so much!