Automation to send form for a sheet at specified cadence

andreadarcy

It would be nice in the automations to send out a form at a specific time, weekly, monthly etc. to emails so staff can be reminded to send over form responses on a project. Not an update, but fill out a form from scratch.

Eric Law

@andreadarcy Why can't you just post the form link in there? Unless there is something I'm missing.

andreadarcy

I did, but it's not a clickable link - defeats the point of what I'm trying to do to make this easier for my staff.

JamesB

@andreadarcy

If you create a helper column, set the name you want in the cell, and the right click and use hyperlink to assign it the URL for your form. Then you can use your workflow to send this cell to the end user as a part of the message and the hyperlink will be active.

andreadarcy

Ok so I did this. It's a great work around, it would be nice though if there was a way to do this in the sheet directly. But I really appreciate this work around so I can utilize it for our team.