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

Writing Formulas in Smartsheet - Self Paced - Optional Activity
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
More granular time options for needed for Workflow triggering
Currently Triggering recurring workflows are only supported at the top of each hour. For instance 10:00, or 11:00, etc. Would like the ability to set 10:30 or 10:45. Perhaps the inteface can stay hourly so it doesnt get huge, but have the ability to manually edit the time directly to any custom time.
"has any of" criterea is only pulling the first item in the cell
I have an automation that has a condition where I am looking at the column "LEA Interco Supporting Site(s)" and trying to find columns that have the value "Fort Loramie" in them. This works well when "Fort Loramie" is the first item listed in the cell, but it doesn't work when "Fort Loramie" is the second or third value in…