Smartsheet API - Is it possible to copy a folder and in the process save calculations as static?

Jennifer Murphy

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!

Gia Thinh

Hi Jennifer,

You may want to visit below forum for your use case. Just for your information.

API & Developers — Smartsheet Community

Genevieve P.

Hey @Jennifer Murdoch

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.