Smartsheet API - Is it possible to copy a folder and in the process save calculations as static?
I am new to Smartsheet API and have successfully used the Postman App to copy and save a folder from one location to another, maintaining:
data
cellLinks
attachments
discussions
filters
forms
rules
My sheets have cross sheet references and calculations. Ideally, I would like to enhance my API process by essentially copying and saving the folder as "static" e.g. that my cross sheet reference formulae copy as static numbers and my calculations the same.
Is that possible? If so, how would I write the parameters?
Thanks!
Answers
-
Hi Jennifer,
You may want to visit below forum for your use case. Just for your information.
Gia Thinh Technology - Smartsheet Solution Partner.
-
I have to admit I've never tried to do this, but I expect you can get the Sheet, identify the displayValue for each row, then input that displayValue as static back into the sheet. If you have column formulas you'd need to add a new column to house the static values.
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives