Update request for cells with cell formula

Grantly

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

Andrée Starå

Hi @Grantly

I hope you're well and safe!

Unfortunately, it's not possible to edit cells with formulas in an update request, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

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!