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.
G