automationmacosnumbers
I have this long formula that is used in a lot of columns:
=SE(N17<60; DEF.NÚM.DEC(SOMA(60; −N17); 1); "✔︎ Aprovado")
So, when I need to change something in this formula, I need to edit each one of then. So to avoid this kind of duplication, can I create something like a macro, which will make me able to do something like that:
def myMacro($POS):
return SE($POS<60; DEF.NÚM.DEC(SOMA(60; −$POS); 1); "✔︎ Aprovado")
And use it like:
=myMacro(N17)
Note: The formulas are in portuguese.
Simply create an Index column. 1, 2, 3 etc. (As pjctec mentions in comments.). Without some ordered list or index, there is no way for Numbers to know how to use a custom sort.
There is no need to use a formula to create the list of numbers.
A1 enter 1A2 enter 2A3 enter 3A1 to A3Sorting will not change the numbers as they are static. No need to use a formula.
Then you can always sort the index column later. If needed, the column can be hidden or shown when needed.
Apple supplies a good resource for Numbers basics on their Website. Numbers Help. Recommended for new users and anyone who wants to get the most out of using Numbers.
Therefore currently this is not possible.
Best Answer
There is rich documentation and deep automation support for Numbers being automated with Automator and AppleScript. Here is a mid-tutorial link to where to save your scripts and shows the menu bar to trigger these scripts.
I could see you entering the formula or substituting / selecting the range for which to apply a function quite easily.
The nice thing about that site is that it has many tutorials as well to cover the scripting syntax / how to use the script editor and all the things you learn in Numbers are general to other apps that have scripting support on macOS - first party apps and third party apps.