Is there a way to autofill a field with a formula, but update it manually if needed?


I have been trying different set-ups and haven't been able to find a solution that works. I want to assign an Analyst to a project based on the Analysis Type. Not all of our Analysis Types are assigned to a particular Analyst. Some are assigned as they come in based on workload. I created a formula field that assigns the Analyst based on the Analysis Type and leaves it blank if the Analyst needs to be assigned. The formula works, but I haven't been able to figure out a way to allow the project manager to go in and assign an analyst in the same field if it isn't auto-assigned via the formula. Does anyone know if there is a way to do this or if there is a workaround I could use to get this functionality? Thanks!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!