=[Due Date]1 - TODAY() How can I make this formula in a way that it only counts working days and not Saturday and Sunday
It would be great if possible to show on the c/c part of an email all the recipients copied on alerts. I have many users requesting to have such functionality in Smartsheet alerts.
Hello Community! I have a question I wanted to bring to the table... I've been working on some processes and workflows for triaging work on my team. Requests come in through an intake form and we have automations to assign to specific resources based on the type of project/request that it is. Now, we are trying to make…
Hello all, I'm currently having a sheet with the answers from one survey form (30 questions). The answers are YES/NO option, but then I would need to convert the YES and NO in 1 and 0. What I did (and maybe I overcomplicated myself) was to create 1 workflow per column. When a new row is created then this triggers the 1st…
I'm thinking of setting up an automated request an update workflow to go out to the assigned column once a week every Friday to manage the construction phase of my project. Only trouble is I want it to send an individual email to each contact in the assigned column not one big email. I have been setting up a weekly…
Hi! I set up an automation workflow on a form I created in Smartsheet. I have tested it twice; with one group it worked and each person received the email notification to approve or deny, however, the other group no email notifications were received to take action. I did not update the workflow between test groups and the…
I have a sheet that calculates a score based on responses from a form. In that form, the user can submit their email that is then added to a contact list column. I have also set up an automated workflow that shares the score from their submission to the email submitted on the form through a message. When the submission…
I work at a manufacturing company, and I am creating a request form for our parts department. The way it is intended to work, is our Maintenance Technicians fill out a form with basic information (their name, part number, priority level etc.). This form notifies the parts department to check into the order and then sends…
Hi All, I have an index/match pulling in data relevant to a Business Unit from off sheet. I need to get it so that I can override this formula data to be blank/allow entering of a different email address by the sheet user. What I have setup already (working with Column formula): 1) User inputs Business Unit (BU) 2) BU auto…
