Hello, Wondering if there is a good way to do this. I have over 20 columns that Iโd like to clear to blank after a certain action has been executed (for example, after the column โstatusโ has been set to โcompleteโ).
I know that this can be accomplished through pairing actions, but this would mean creating over 20 โset the value of a columnโ actions.
Anybody know of a more efficient way?
You can go to each of 20 columnโs app formula and write a formula to be blank when [Status] column is changed to โCompleteโ or You may write an Google Apps Script to handle it in the backend in Google Sheets.
Thanks for the response. Would the app formula work for those columns where there are user inputs? Such as a text column type.
@Jenn_M App Formula column wouldnโt be editable. You are right, may be better go with Google Apps Script
User | Count |
---|---|
42 | |
28 | |
25 | |
22 | |
13 |