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

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?
Answers
-
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.
Thanks,
Aravind GP| Delivery Manager
Atturra Data & Integration
M: +61493337445
E:Aravind.GP@atturra.com
W: www.atturra.com
-
Thank you. I had thought that was probably the case but wanted to confirm. Thank you so much for your help.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!