-
New Workflow Already Met Condition
Hello, I have a workflow that I just added and the cell to trigger the workflow already met the condition trigger so the email should be sent however I tested that and email not going through unless I do it manually. The reason is the cell status already has the trigger word. Is there a way to trigger the condition to send…
-
How do I automate copying a subset of fields/columns to another sheet when criterion is met?
Hi, I built a request form with several fields. The requests will then be reviewed and either approved or rejected. Is it possible to build an automation that copies data in some fields/columns to another sheet only if the request is approved?
-
Workflow not working
I've set up an automated workflow and can see that it has "ran" however, email alerts are not being received. Have tried several tests with no success. Have also checked everything I can think of setting wise and a bit lost on this one, considering I've had success with similar workflows.
-
Workflow Runs but appears not to recognise condition
Hi I created a Sheet that continuously counts the time to a monthly meeting (4th Wed of the Month). The sheet has been checked and gets the correct date and interval. I use this date to calculate the interval / days to next meeting with a formula =[4th Wednesday of the Month]6 - TODAY() in a Column titled "Meeting…
-
Automate Onboarding Survey
I am learning so much at Engage '22! I am excited to start using workflows to automate our onboarding survey results form.
-
Trigger an Automation after an Event is over (Time specific workflow)
Hi everyone, I manage producing events in higher ed, and I'm trying to set up a workflow which sends a recap automation to our workers after an event is over. This is to collect notes and details with information from boots on the ground to help build reports and dashboards. In our sheet we have a column for date, and then…
-
Alerting Contacts in a cell
Hello, We have a sheet that we use as an IT ticketing sheet and Form. I setup an automation so that whenever a comment or attachment is added to a row it will notify (email) whoever the assigned technician on that ticket is. This works great when the end users comment, however, when the IT technician makes a reply or a new…
-
Need some help with a health formula for task risk level analysis
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…
-
Best way to show KPI's across multiple projects and teams?
Hello all, I'm trying to determine the best way to capture multiple KPIs on a dashboard. Each cross-functional team has their own sheet where they manage projects. What is the best way to have them capture data metrics (the KPI's might be different per team- hours saved, increased NPS, $ Saved) that roll up to a dashboard?…
-
Backend Process for creating Workspace and Project Folder
Hello, Currently we create a new workspace for each projects even if that project has different Location, (ex. X Los Angeles, X New York, X Vegas) will have separate workspace. However, we want to create a one workspace for the same Project and have folder inside that for different location. So X will be the Workspace Name…