Is it possible to use the LEFT function across multiple columns?
I am building a UAT smartsheet that is working really well. However, i want to calculate the tests performed using the test reference i have created for each test. I have successfully used this formula for a single column, BUT need to have it work across multiple columns, does anyone know if this can be done, and if so, whats wrong with my formula?
This formula works, it pulls the first 7 characters from the row within this column
=LEFT([Accounts Receivable Test Reference #]@row, 7)
I want to expand this across multiple columns, using this below, but it is unparseable, any suggestions on where i am going wrong?
=LEFT([Bank Reconciliation Test Reference #]:[AT Statement Test Reference #]@row, 7)
Help Article Resources
Check out the Formula Handbook template!