Trying to set up options to fill cell itself or from a formula in another column.

Laurie D

To track staff attendance, one column (Call Out Type) we have is a drop-down with 5 options. We want to have a separate column (Call Out) that would be included in the form the staff fill out when calling out that would include 3 of the 5 options. I set up a formula that would copy the value in the Call Out column into the Call Out Type column. Now we are not able to enter a choice directly into the Call Out Type column. Also, the supervisors have a form they fill out as well and they had the Call Out Type, 5 option column on their form until I created the Call Out column and now Call Out Type is not an option for their form. I can just change the staff form to include all 5 options but I is there a way to have the option to have the column populate through the formula or by filing the column itself?

AravindGP

Hi @Laurie D

The short answer is no. When you've a column populated through a formula, there's no way for manual data entry.

Laurie D

Thank you. I had thought that was probably the case but wanted to confirm. Thank you so much for your help.