Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able to send subsequent email updates using the same email thread in the G-suite. Not sure…
I set up a workflow to add contacts listed in a sheet to a contact drop down of another sheet, however the workflow takes about 10 minutes to run since it is building an array with a child workflow. Does anyone have a cleaner way to take contacts listed on a sheet and update a contact dropdown?
I have a form we are using to collect information on team activities. One of the form fields is a multi-select column where entrants can select all of the partner teams they will need to conduct the work outlined on the form. I'd like to send an alert to a "point of contact" for each team that is selected as a partner. The…
Hey there! I am working with a large archival destination sheet: We haven't hit 20k rows YET, but it'll probably be coming this year. The automation moves Completed rows from an active tracking sheet to the archive sheet- we keep that for a full accounting of these completed processes. But.... what happens when…
How do I create a workflow to send reminders to the row owners if no changes happened to the row in the past week?
I'm building a workflow for our HR and Recruiting department to use to track job posting requisitions. If they check a box on the master sheet to repost the job again I am copying the row to a staging sheet, making a few cell updates to change values or clear values, then want to move it back to the master sheet as a new…
Hello, I am looking for a way to have certain cells in a row "reset" once a checkbox (in that same row) is checked. When I say "reset", I want two cells to go back to being empty and another cell to have an updated quantity. Is there a way to do this? Maybe multiple automations? Appreciate any help or ideas!
Operators will enter Paint Code, Line Speed and the Date is created at the time of entry. There are MANY paint codes. How do I create a formula or workflow or BOTH to notify a manager WHEN the paint code has a lower line speed than the last time it was entered? Example below.
Hi. How can I create a workflow that does the following : Once a user fills in data in the dynamic view of sheet1, a form will be sent to them from sheet 2? Thanks.
Hello, I have a few questions below regarding Smartsheet: We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete. How can I remove the time in "Created", I would only like to have the date. (photo 2) Question 1 Explanation below: I've noticed…