Hi, Can I send an email to a Smartsheet, whereafter the Smartsheet does this: 1, locate textstring in email. 2, compare text with row. 3, send email or textmessage to a person in a contact cell in that row??, Thanks in advance /Poul.
Hi @Poul Thomsen
It might be possible to create a solution in Smartsheet or with the help of a 3rd party service/solution.
Can you describe your process in more detail?
That would make it easier to help.
I hope that helps!
Be safe and have a fantastic day!
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
We have a number of rooms with freezers. The freezers are supervised by the building automation system. In case of high temperature in a freezer, an email is send to the officer on duty. The email consist of a lot of information, timestamp, technical adress and room and location.
We have 'Parent' smartsheet, which has linked information from child smartsheets. In the child sheets are a row for each freezer with up to 10 persons to call in case of high temperature. The contact info is maintained by local labmanagers.
The officer looks in the Parent Smartsheet for room and freezer ID, and then in turns calls the contact persons.
To make this more effective and bulletproof, I am looking for a solution as mentioned. I know there are companies that can send voicemails and/or text to mobile phones, based on an textstring with relevant info.
I believe the biggest tasks are to find the relevant information in the alarm email, then find the relevant row in the parent sheet, and then email/text/call the contactpersons - maybe also in turn.
Against is, that the building automation system also sends a lot af other emails regarding failures on other equipment, and solution shall ignore those.
When managing a PMO. is it considered a best practice to establish an individual workspace for each project? If this is advisable, is there a method for setting up an automated recurring backup for all projects without having to do them individually?
Hello all! I have an automation workflow set up to record a date when a particular column changes to a specified value. Essentially I need to record a date when the "Current Stage" column changes to "Reevaluate/Schedule Final". See the workflow trigger screenshot below. I created this workflow and tested it on 11/16. It…
I use Outlook with my company. When a tagged email comes in from Smartsheets, I click on the "reply in Smartsheet" and it won't take me to any conversation box. It just opens the page, but not on the line that I need. Why is this happening? I updated this morning. Also, I get an Error message sometimes.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.