You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

User profile for user: Dope84
Dope84 Author
User level: Level 1
5 points

Numbers formula mass change.

In Numbers 10.3.5 I have a document with sheets that contains transactions for each year. In sheet 'Overview' I have a column for each year and a row for each account where formulas calculate the values. Now I copy column '2022' to a new column '2023', but fail to find the way to change value '2022' to '2023' in all the formulas in one go.

Can anyone help?

I saw another semilar Q earlier and that SGILL provided a link to download a solution. But the link doesn't work anymore.

Posted on Dec 29, 2022 9:29 AM

Reply
Question marked as Top-ranking reply
User profile for user: SGIII
SGIII
User level: Level 8
36,128 points

Posted on Dec 30, 2022 7:57 AM

Here's a Shortcut (run in built-in Shortcut app or pinned in Menu Bar, etc.


https://www.icloud.com/shortcuts/35b26cc01bd34dfc82b647c52cfb7339


If you are running Safari you should be able to click the link above, inspect the shortcut, and install it.


Thereafter, to use it just select cells in a Numbers table, run, and answer the prompts.


It will change the formulas in cells with formulas and ignore cells in the selection that do not contain formulas.


NB. In the Shortcuts app you may have to go to Settings (Preferences) > Advanced and check 'Allow Running Scripts'.


SG





View in context

Similar questions

3 replies
Question marked as Top-ranking reply
User profile for user: SGIII
SGIII
User level: Level 8
36,128 points

Dec 30, 2022 7:57 AM in response to Dope84

Here's a Shortcut (run in built-in Shortcut app or pinned in Menu Bar, etc.


https://www.icloud.com/shortcuts/35b26cc01bd34dfc82b647c52cfb7339


If you are running Safari you should be able to click the link above, inspect the shortcut, and install it.


Thereafter, to use it just select cells in a Numbers table, run, and answer the prompts.


It will change the formulas in cells with formulas and ignore cells in the selection that do not contain formulas.


NB. In the Shortcuts app you may have to go to Settings (Preferences) > Advanced and check 'Allow Running Scripts'.


SG





Reply

Numbers formula mass change.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.
Learn more Sign up