- lookup in smartsheet within a zapier flow
Does anyone know how to do a lookup in smartsheet within a Zapier flow? Something similar to a Google Sheet lookup functionality?
- Find the source sheet of an automation email
Can anyone tell me how to find the source sheet of an automation email? An email was sent to someone in error which they forwarded to me but there is not enough information on the notification to identify which sheet is the source of the automation? There is an ID at the bottom of the notification, am I able to use that to…
- Sending automation (alert) including an attachement
Hi, I have row with either one or two PDFs attached that the document builder just created based on the data from the row. I'd like to add an automated trigger to send the attachments to the user (contact in a column). Is there a way to just include the attachments in an alert email? Thanks, Zsolt
- How to delete rows automatically
Community; I manage a process that injects a fairly high volume of rows into a sheet at least weekly. These rows are meant to be viewed by a sales team, annotated, acted on, and then archived. After about a month they lose all value (key data points are moved into our ERP or POS backend, depending on outcomes). But the…
- Calculation within IF statement
Hello, I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise…
- Formula for Referencing Cell Above Current Cell?
I have created this Smartsheet, where my team can record orders raised each month. This would then link to a dashboard (which would have to update automatically each month) to show monthly statistics regarding the orders from that month. This is what It currently looks like. Each month is child of its year and the orders…
- How to Send Timed Reminders Based on a Trigger?
Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declination. I'd like to send reminders if no one answers that approval, though. What I'd like to…
- 使用自动化/工作流复制多ple languages form responses into one sheet
Hi, I have two forms one in English and one in Spanish. They provide exactly the same responses, just in their respective language. The Spanish version still has the field headers in English while the labels are in Spanish. I have created an automation that filters for a particular school and creates a copy of the row on a…
- Linking three regional sheets to reflect in one global master
I am creating three sheets to track projects through the Americas, APAC and EMEA regions all will have the same column headings and will be updated by regional teams. I'd like to create a consolidated Global view of the projects bringing all regions together in one sheer that updates automatically when a change is made to…
