I have a column named "Ready". I want to change the color of the cell in that column to green if the cells in these five other columns all contain "Located" or "Clear". I've figured out how to check a box if any of these columns contain "Delayed" but I want a visual representation if the row is completely ready. I've tried…
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…
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…
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…
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.
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…
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.
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?
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…
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…
