Can you make variable text that automatically imputs the spreadsheet name?

I make invoices and quotes in Numbers. A new quote/invoice per sheet. The sheet name is the invoice/quote #. Is there a way to make the quote/invoice # on the sheet automatically change when I duplicate and change the sheet name?

iMac 27" 5K, macOS 10.14

Posted on Nov 26, 2019 8:04 AM

Similar questions

NUMBERS: How to insert sheet name into a cell? I have a sheet called "Money" Now I want to have a cell update its own content based on the name of the sheet, so if I change the name of the sheet to "Shopping", then the cell would also change to "Shopping". I have found this thread, but for some reason it's not working for me, any of the solutions they provided: https://apple.stackexchange.com/questions/265561/how-to-get-the-current-sheet-name-into-the-cell-in-numbers-app I tried copying and pasting what they have, also tried doing it manually. No luck. I have Numbers 11.1
3464 2
Sheet name in a cell How can I put the name of the sheet in a cell automatically? Thank you!
1035 2
Variable portions of text from cell Hi everyone. I have document composed by 20 pages. on the 21th page I have few cells with the main datas of the document itself (like "client name", "client age", "client address") Is there any way to automatically change selected portions of text in the middle of the document (as "client name", "client age", "client address") with the new one specified in my page 21? if it was Numbers or if I was dealing within cells this would have been easy, but from cell to text is harder.. thanks a lot for your precious support Al
350 3

1 reply

t quinn

Level 5

7,083 points

Nov 26, 2019 10:58 AM in response to Xacob

Hi Xacob,

You can send a formula to a certain sheet but there is no formula I know of that can retrieve a sheet name.

quinn

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Can you make variable text that automatically imputs the spreadsheet name?

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