4

Hello SmartSheet community, perhaps someone can give me ideas on how best to set up the following:

I have 30 customers and 30 different reps (one for each customer) who need to provide a status on that customer on a regular basis, at least once every two weeks.

The requirements:

  1. Use a simple form to

1

I am looking for any method that could help me obtain the desired results.  I have a tracking sheet titled “PM Sales Tracking” and within the tracking sheet there is a column that is called “Design Request” I have edited the column properties(design request) to a “dropdown list” with values of “yes

2

I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possible values (in this case, a property). 

What I would like is to have have any rows in the source