Same formula for 500 columns
Is there a quick way I apply same formula for 500 columns (having column names different)?
-
Hello Umasankar.
The easiest way to introduce the same formula to 500 columns is to:- Build the Workbook until the Sheet where you want to introduce the formula to 500 columns.
- Add the desired formula to the 1st column.
- Download Workbooks JSON definition via REST API.
- Use a convenient text editor to duplicate the formula required number of times. You might want to put together a short script that helps you.
- Upload the Workbook back to Datameer via REST API.
I hope this approach helps you to proceed further with your use-case.
Please sign in to leave a comment.
Comments
1 comment