Is there a way to automatically add a comment as part of data validation. For example, if 1 is selected, then show "Approved" as a Comment in the cell, if 2 is selected, then show "Rejected" as a comment. This is a simple example but basically, the text we'd like to show is quite long so would rather keep it as a comment vs. in the cell.
Solved by T. E. in 23 mins