I have an SP Library.
I created several calculated columns in the Library (using LEFT, RIGHT, MID) to break-up the content of the 'Name' column.
Everything works fine; however, I was having a conversation with an individual yesterday who told me I should limit, if not eliminate calculated columns.
His reasoning, due to their adverse impact on the Library, queries to the Library, and the way a Library (or a List) interacts with Power Apps.
Can anyone comment on the value and proper use of calculated columns; should I be performing these tasks through Automate; does it matter?