Can a field have a formula, and be editable??

I'm a relatively new user of Smartsheet, and am amazed at both its capabilities and the engaged community -- I've found answers to every question I've had. Until now...


I have a solution I'm creating where there are multiple fields for components that make up a product. Because not all fields are necessary for every product, I created a formula to apply "N/A" based upon values in other fields. However, this is preventing user entry in an Update Request into the field where needed.

Is there a way to have a column formula, but allow user entry (via an Update Request)?


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!