My objective right now is optimizing my worksheets to have as little human interaction as possible beyond entering inputs. To that end I have users input their data through web forms to populate my sheets. My issue is that I cannot generate hyperlinks automatically on the new rows created by the web-form. I have to manually go in and insert them. Also I cannot generate new rows on more than one sheet with a web form (both are highly dependent I suppose.) Are there any workarounds to this currently? Is this another feature that could be added in the future? (I can't use google sheets most similar programs, my companies IT/security policies prevent that, we have been approved for Smartsheet and that is it so far)
