Automation

I have a sheet which has all of the training details of people who work for us. Previously I have set an action every week to email people whose certificates have expired to remind them to send me their new certificates. I want to use the new automation function to do this for me, however I can't see how to trigger it...?! Currently it is triggered by date, but the weekly option is disabled if I try to select that on a new rule. Can anyone help...?

Find more posts tagged with

Construction

Sheets

Integrations

Project Management

Comments

Andrée Starå

Hi Kirstine,

If I understand you correctly, you'd start the Workflow with another Trigger and then select Run Workflow: Weekly.

Please see attached screenshot.

Would that work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Screenshot of Google Chrome (2019-05-13, 13-02-45).png

Kirstine

Hi Andrée,

Thanks for this. Do you mean that I just use a trigger and then force it to 'activate' (by changing a cell for example), at which point it will just start running once a week from then on?

Kirstine

Hi Andrée,

I've trialed this using the hourly option to my email address but it just sends it once...?

Kirstine

I've figured this out myself now!!

Make the Trigger *When a date is reached* then use the *Run once* dropdown to chose *Custom*.

This takes you into a Custom Recurrence menu, where you can set the details of the reminder!

Paul Newcome

I was going to suggest this, but I see you already figured it out. Excellent!

Andrée Starå

I misinterpreted your question!

Glad you found the solution.

Best,

Andrée

Kirstine

I can understand that... I'm a very confusing person! Sorry to baffle you!

Kirstine

Thanks anyway Paul... great minds think alike!

Andrée Starå

Haha!

I meant that it was me that got it mixed up with the new Automated Workflows.

The important thing is that you got it working!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Anyone getting JIRA API errors using the connector?
We are using the Jira/Smartsheets connector and got this error: Invalid response from JIRA. statusCode: 410, reasonPhrase: Gone The requested API has been removed. Please migrate to the /rest/api/3/search/jql API. A full migration guideline is available at Looks like the connector needs to be updated. Anyone know anything…
Dirty save - #BLOCKED/Invalid Value issue when using integration until manually save the sheet
Hello everyone, We’re facing a critical issue in one of our Reports. We use integration and it adds values to the sheets. The corrected values don't seem to auto-save. Formulas in sheets first show #BLOCKED/Invalid Value, then if we refresh the sheet - it updates to the correct numbers. The save button is active even…
Smartsheet for Google Drive doesn't seem to be available anymore
Trying to access Smartsheet for Google Drive and it seems it's not available anymore: https://workspace.google.com/marketplace/app/app/46145466229 Also the app is not listed when searching on Google Marketplace.