Google Sheets - Default Data Validation

[tomoki]

Hi,

 

I was wondering if I were to have Google Forms drop data into my Google Sheets,  I would want a sort of ticketing system where the data validation on column C for instance, be "Open" as the data from Forms gets dropped in. Would that be possible through data validation? Is there some way to do it? 

 

My arrayformula doesn't seem to be working very well either. When the data gets dropped in from Google Forms, my formulas get wiped out and arrayformula doesn't actually do anything. 

[kirashi]

1 hour ago, tomoki said:

Hi,

 

I was wondering if I were to have Google Forms drop data into my Google Sheets,  I would want a sort of ticketing system where the data validation on column C for instance, be "Open" as the data from Forms gets dropped in. Would that be possible through data validation? Is there some way to do it? 

 

My arrayformula doesn't seem to be working very well either. When the data gets dropped in from Google Forms, my formulas get wiped out and arrayformula doesn't actually do anything. 

Absolutely possible - you could read the data from the form/result spreadsheet into another sheet and do what you need to with it there.

How you would go about this is beyond my knowledge though, since I'm used to working with Excel or MySQL databases for this kind of stuff.

(Despite Sheets and Excel both being spreadsheet platforms, there are too many differences for me to care about Sheets at this time.)

[tomoki]

3 minutes ago, kirashi said:

Absolutely possible - you could read the data from the form/result spreadsheet into another sheet and do what you need to with it there.

How you would go about this is beyond my knowledge though, since I'm used to working with Excel or MySQL databases for this kind of stuff.

(Despite Sheets and Excel both being spreadsheet platforms, there are too many differences for me to care about Sheets at this time.)

Thanks for the reply The only thing is, I tried using a query to pull data from the form that Google Forms dumps all data into but whenever people are done dealing with the specific ticket, I would want them to put initials in. The problem with that is, whenever you put initials into a query based sheet, the whole sheet just basically becomes corrupted. 

 

If at all possible, I would want the initials to end up on the original sheet somehow. I hope that makes sense.