Sign in to join the conversation:
I'd like to send a weekly alert/action to remind each owner on the sheet to go into the sheet (not using a form) to make their updates. What's the best way to do this? Thanks!
Hi Stephanie,
I would recommend setting it up with the help of Alerts & Actions or with a scheduled delivery as an attachment of the sheet.
Which method would you prefer?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I'd like to generate some kind of alert. The email would ideally have a link to the sheet instead of a link to a form...
Ok.
Recurring alerts are coming but aren' available today so I would recommend scheduling to send the sheet as an attachment or send a weekly report. It's possible to set up an alert to trigger, but it's more work to set it up.
Would that work?
Andrée
What if I did it manually each week? I'm trying to get an email to generate for each person shared to the sheet that takes them back to the sheet and not a form.
There will be a link back to the sheet automatically included. If you'd prefer you could send it out manually, but it will probably be cumbersome because you would have to add the email addresses manually.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Andrée
Sheet has been shared. I simply want to generate an email to each person shared to this sheet. It would serve as a weekly reminder for them to go into the sheet and to make their weekly updates on status, % complete, etc for the projects they own. Thanks!
I misread your question. If the users are shared you can manually email all users or set it up to be automatic. (I've also emailed you a screenshot)
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…
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.
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…
