Display formula result in form
I have a column formula that grab a link from reference sheet and I need this to be displayed before submitting the form.
Example, column A is a drop down of items, each of these items can be downloaded from a shared link.
So in column B I added a formula to grab the link from referenced table.
However in the form I cannot add column formulas to display their content while filling the form which I need to display for the user.
Other solution could be to email the user upon submitting the form. But that also will not contain column B as its not part of the form.
Any idea would be appreciated.
Help Article Resources
Check out the Formula Handbook template!