Automations
Discussion List
- Hi, I'm having trouble nesting AND & OR statements with the ISBLANK condition in my IF statement. I have two columns: [Agreed End Date] and [Actual End Date] =IF(AND(NOT(ISBLANK([Actual End Date])), (…
- I'm trying to create a sheet that uses some but not all of the columns/information from a different sheet. Is there any way to use the copy row function but copy over only the columns I need? Or is it…
- I have a smartsheet that pulls data from a different one, and with this a verifier that changes are being made. This verifier has a workflow automation that triggers on rows changing that is supposed …
- As a project manager and smartsheet admin I have found it very useful to setup workflows that notify ME when other people make changes to smartsheet, however, I find that whenever I create a template …
- Hello! This is my second question here. The community was incredibly helpful for the first one! :) - I want to pull the Top 5 Customers with more active projects from a project tracker (the user input…
- We are setting up alerts via automation and using an Outlook Mail Group email ID (CSIHOpExTeam@iqvia.com). This is NOT sending emails to outlook like usual. Has anyone been able to get this to work? D…
- Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. …
- Hi I'm using the "Request an Update" function in automation and this works ok, I've noticed though that due to no fields being mandatory that a user can just submit the form without making any changes…
- We want to use the Salesforce Connector to link data from individual smartsheets back to individual Salesforce records. However, we don't want to have to create a Smartsheet connector Workflow for eac…
- Hi all I have a sheet which has a deadline on it. This deadline may be extended for a variety of reasons (unable to get parts, Waiting for a return email etc) Is there a way to have a check box that, …
