sonypsunny
New Member
Hello
I am using spreadsheet to track call inquiries that come on the phone in order to track new and existing(already mentioned in the Q&A company intranet) inquiries. My issue is I can give data validation for existing inquiries (helps me reduce typo error) but when a new inquiry comes I use another column to enter the data and so it's difficult to analyse the data as lots of data are there. Is there anyway to combine these two columns without eliminating data validation since typing error is a big issue. Any help is appreciated. Given below is a sample of my sheet.
[pre]
[/pre]
Thanks
Sony
I am using spreadsheet to track call inquiries that come on the phone in order to track new and existing(already mentioned in the Q&A company intranet) inquiries. My issue is I can give data validation for existing inquiries (helps me reduce typo error) but when a new inquiry comes I use another column to enter the data and so it's difficult to analyse the data as lots of data are there. Is there anyway to combine these two columns without eliminating data validation since typing error is a big issue. Any help is appreciated. Given below is a sample of my sheet.
[pre]
Code:
Date Inquiry Other Inquiry Assigned to Caller Name
02/05/2013 Vacation Tony Ted
02/06/2013 Terminate Ron Ravi
Thanks
Sony