Forum Discussion
Getting around character limitation in Data Validation (Source)
Dear colleagues, It turns out that I am to build a spreadsheet so we can gather interesting data about HR demand management. The point is that, so as to avoid human errors, we would like to have ...
Sample file please.
Hi Logaraj,
Please find attached my first attempt named Hiring Overview (using nested IF formulas -here I got stuck due to character limitation at column 'Department') as well as my second attempt Hiring Overview_2 (using dynamic arrays -here basically I have to create a dynamic list for each and every drop-down cell :S-).
Thanks a lot!