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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!