-
Do Update Requests ignore row locks
I am using quite a few workflows to automate a sheet. There can be situations where a row Update Request has gone to someone and before they respond to it another action causes the row to be locked. We've tested this scenario and it seems that the Update Request can be completed and the row is updated even though it is…
-
Move a row to a new sheet based on an entry on a separate sheet
Hello, My company has a sheet titled active employee roster which has every employee in the company. We are trying to create a new Offboarding sheet that will then find the employee on the Active Employee roster sheet and then move them to a 3rd sheet labeled Offboarding Archive. I am struggling to create a solution for…
-
Email ical file to Contact
It would be fabulous if there was a way to send information in a row in an email as an ical file. We coordinate the scheduling of all our external trainings in Smartsheet, but then have to do extra data entry because we then have to create a meeting in Outlook (100% of the time) and in Zoom (40% of the time). Being able to…
-
Can you create a workflow that emails the line attachment as an actual attachment instead of a link?
I have a smartsheet that creates a certificate once the user details have been entered, then emails a copy of the certificate to the user once an email address has been added, but would be better if the line attachment was attached to the email instead of just a link to the attachment.
-
Date calculation formulas are not working properly.
Hi, community. I have a weird problem with my metrics sheet and the dashboard linked to it since it is displaying fault information with a specific formula. I have tried a lot of workarounds, including the update of both source and metrics sheet and a lot of different formulas but I can't still fix it. Formula is as simple…
-
Add HTML formatting in Automation Workflow Notifications
Would be great if we could force wrap text within an Automated Workflow Notification Alert "Message" using </br> HTML tags, and/or be able to <bold> text directly within the Message we're setting up. Hoping this can be an enhancement one day to Smartsheet.
-
Using the new customized sender in automations: Send from Smartsheet Automation
I thought this new feature would also update the reply-to email as a generic donotreply email address. But it looks like the reply-to email (at least for an alert type of automation) goes to the owner of the sheet. Is the only workaround to create a user with a generic donotreply email and transfer ownership to them?
-
Moving rows to another sheet
I am trying to set up an automation where rows are moved to different sheets based on an account number. I have 4 set up just fine but I have 3 more that when I go to choose the sheet I want it moved too, it's not available. I am the owner of all the sheets and all sheets were created more than a week ago. I tried to…
-
Emailing the admin group through automation when a row is added.
Since Smartsheet changed the way you add users and domains (outside of your domain) and made it a sheet, I want to setup an automation on where when a new row is added either by form or manually it will send a notification to a group. The group I want is the admin list in Smartsheet. Is there a way to do this? When I state…
-
Automation spanning multiple sheets
Current organization: within a single folder, there are about 10 sheets, each for a different project. The same Assignee will be present in multiple sheets. I want an automation that will send a daily email to each Assignee listing all of their open tasks (i.e. start date has been met). I can do this for each individual…
