Workaround for if statement from form
Hello,
I was hoping to get some help with a formula/workaround in the following scenario:
-A client fills out their information as the "submitter" in a form (Column 1).
-The client is asked in the form if they are also the authorized representative from their organization to sign a DocuSign integration (Column 2 - Is the submitter also the authorized signer? - yes or no)
-If yes, form logic does not ask them about Column 3 - authorized signer column (we are trying to reduce duplication on their part), so it come through on the processing side as blank
I want to use an if/then statement that is something like this in Column 3: =IF([Column 2]@row = "Yes", [Column 1]@row), but I need to incorporate an option for the "false" component that retains the information submitted in the form if Column 2 = no.
I think I understand that typically, form-submitted information can't be changed with a formula, but I am wondering if anyone has thoughts on a work around? Otherwise, my team is currently copying and pasting info from Column 1 to Column 3 if applicable. I am worried that this is opening the door for error.
Thanks in advance!!
Marleigh
Answers
-
You would need to put the formula into a 4th column.
=IF([Column 2]@row = "Yes", [Column 1]@row, [Column 3]@row)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 352 Global Discussions
- 198 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 443 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!