Form completion populating in a sheet
Hi! I am attempting to figure out how to have a box checked on a sheet once a form is completed. Can anyone point me in the right direction?
Thanks!
Answers
-
Hey @CMPeterson2013
If you mean check the box when the form is submitted, you have many options. You can look for any required field in your form to be not empty. If you don't have the system columns Row ID, Created or Created By - any one of these could also be used.
=IF([the column you choose]@row<>"", 1)
Edit the formula above to either a field that is required by the form, or any of the above mentioned system column names that you have in your sheet.
Does this work for you?
Kelly
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