Welcome!

Auto reply to a form

I was wondering if there is a way to have someone reply automatically to a form when asked for a reply

Forms

Sheets

Hi Justin,

Can you tell me more about your use case?

Best,

Andrée Starå - Workflow Consultant / Get Done

I am looking to have someone reply back to the person who made the request

It sounds to me that you maybe could use an update request instead for this.

Would that work for you?

Best,

Andrée

It will work however I want to be able to automate an update request

You can!

Either thru a recurring option or thru the Alerts & Actions function.

Would that work?

Best,

Andrée

Yes that would work. How would I go about doing this?

Hi again Justin,

Please see attached link/screenshot or file.

Option 1 (Recurring update request)

Option 2 (Automated update request)

You could set a checkbox to trigger the request.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Image 2018-05-02 at 4.46.18 em.png

Image 2018-05-02 at 5.46.25 em.png

Referencing to Smartsheet table (consisting of 30+ columns) in INDEX/MATCH formula but shows error
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
Delete
How can I delete old sheets I no longer use from my account?
How do I get a dashboard chart based on a report to display as a donut chart?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…