Update request for cells with cell formula

Hi Smartsheet Community,

I'm trying to automate an update request for a daily form submission. The data are entered to the source sheet from the form and I've used cross-sheet formulas to pull the data in the the format needed for the document builder sheet.

However, when I run a test Update Request for empty fields in the document builder sheet, no text box appears for those cells with cell formulas. However, I can enter data into these cells from the Document Builder sheet itself. My question is if it's possible to edit a cell with a formula from an update request?

For clarification, I am the owner of this sheet so permissions should not be an issue. Thank you, in advance, for your time and (hopefully) assistance.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!