-
Microsoft Power Automate can not reach sheets
Hi there; i would like to use microsoft automate to change a sheet to excel online by a flow.But on powerutomate step when i want to choose sheet , power automate only see workspaces , and folders , when i choose a workspace and then under it a folder , after this step automate says there is no any sheet .Why it can be ,…
-
Autopopulating Dates on a Sign-up Sheet
Hello, Does anyone know if there is an option to auto populate dates for a sign-up sheeting on SmartSheet? For example, I have sessions that individuals are allowed to select from October to December. However, I do not want those dates to show up after they have passed. So, if today is 10/4, then I do not want my sessions…
-
Workflows > Actions: Request an update > Recipients: Contacts in 'contact in row'
I’m having an issue with a workflow being executed, but emails are not going out. I first thought it was because our security was blocking emails, but that is not the case….did a sample to my personal email address (which is less stringent), but still no execution. When I performed a test “request an update” on 13-15…
-
How can we automate a quarterly email with Smartsheet content in the body?
We have a Smartsheet with some content that I would like to format in an email in such a way that recipients are able to act upon information without needing to look at the Smartsheet. We have a list of Key Users in a column who I would like to send an email each quarter. If possible, I would like to include the name of…
-
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…
-
Is it possible to send ONLY an attachment as an alert?
Hello, Is it possible to send only an attachment as an alert WITHOUT the link to the sheet? I need to send them the file but do not want them to see or have access to the sheet at all. Please help, thanks!
-
#NO MATCH due to Smartsheet bug
I received this message after submitting a ticket to Smartsheet. As there seems to be no end in sight I'm curious if anyone else is having the issue and if they have found any solutions to resolve it? ---------------- I'm from the Escalations team here at Smartsheet Support. I was looped in explaining that you are seeing…
-
Workflow: Repeat Email Address Instances
I have a column where there are 20+ instances of the same email address. If I create a workflow which sends an alert to all contacts in that column, will it send the alert 20+ times to the same email address? Or does SmartSheet have a failsafe which will only send the alert to that email once?
-
Multiple approvers simultaneously
I am trying to create a workflow that allows form responses to be sent to multiple people to approve at the same time. Currently, how I have it set up, there is only one approval cell available, which means that only one person can truly approve the form responses. I am wondering if there's a way to add multiple cell boxes…
-
Combining rows with like names
We have a sheet set up with forms to allow for participants of a contest to #1 register for the contest, then #2 go to the second form to update their progress in the contest. Is there a way to combine rows when a someone submits the same name or email address, for easier tracking? Something that is automated to create…
