How to get my formulas be copied with my backup or exported MS Excel file?
Good morning, Smartsheet community,
How to get my formulas be copied with my backup of exported MS Excel file?
I have a problem with all my formulas not being copied when I create a backup file (using a Backup request feature) or when I export my smartsheet to MS Excel file.
Is there any way to include all my manually typed formulas to backup or exported file?
Thank you!
Kind regards and have a great day.
Oleksiy.
Answers
-
I hope you're well and safe!
Unfortunately, as far as I know, it's not possible now, but it's an excellent idea!
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi @Andrée Starå,
Thanks for the prompt response.
I hope Smartsheet will add this functionality in the near future.
Thank you!
Kind regards and have a great day.
Oleksiy.
-
Hello @Oleksiy Yefimov
As a workaround for this, I enter all my formulas (noting any cross reference sheets) as Sheet comments. Then when backup is completed of the sheet, those comments show on a separate tab in the excel sheet (that is downloaded from the backups). Not ideal, but an option.
Thank, Peggy
-
Yes, I agree!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hello @Peggy Parchert,
Thanks for your respond.
Good idea!
Thank you!
Kind regards and have a great day.
Oleksiy.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives