-
Removing Unsubscribe Option from Automation E-mails
Hi all, Is it possible to remove/hide the "Unsubscribe" button from automation e-mails? We had a team member accidentally unsubscribe from alerts that were imperative for them to be getting and it rendered the automation workflow disabled. Thank you in advance!
-
What does this Automation Alert mean?
Can anyone explain to me what this alert means?
-
Copy row with a new date in cell
I have 2 sheets set up, a source sheet and a destination sheet. Every morning I need the source sheet to copy over a row to the destination sheet with a date based on a formula, today()+1. The problem I am running into is that unless I open the source sheet everyday to trigger the formula the date copied over has the old…
-
Auto generate project number using formula
Hi, I'm trying to create a formula that will auto populate the project number when a new project is created through a form. When a project is added through a form it appears at the top of the sheet. Our project numbering system is YY-XXX where YY is the year of the start date of the project and XXX is the project number…
-
Different Renewal Dates in Each Row
Hi I am trying to add a formula to add months to a date but each row are different months, I would enter the last renewed date and then the next column would auto update. For example I have used this formula =([Last Renewed]@row + 365) but this uses the same formula of the whole column also this is using days and not…
-
Removing Total Row from Smartsheet Reports
I am creating several reports that subtotal financial information by various groups (i.e. revenue, numerous expense categories, EBIT etc.). I do not want the reports to display a total row that sums all the revenue, expenses, and profit as this is misleading. Does the functionality exist to turn this off?
-
Moving selective data when original sheet is populated
Hi I have a form that populates a master sheet. How can I create a workflow that fills in a subset of columns in a second sheet after filling out a form? Smartsheet's workflow that moves a row to another sheet, unfortunately, moves a row and all of its columns. The issue is that I cannot use INDEX COLLECT or INDEX MATCH…
-
Automation flow adding new rows per unique value
I am working on an database set-up where I want to store both historical and future data on a quarterly basis (e.g. Q1 2020, Q2 2020, Q1 2021 etc.) for different European cities (e.g. London, Madrid, Berlin, Prague etc.). What I want to do is build an automation flow that will automatically add a new row per city when a…
-
Do I need to use Quotation marks when I like to trigger an action based on a Phrase in a cell?
Do I need to use Quotation marks when I like to trigger an action based on a Phrase in a cell? In my template is used for testing. It contains a contact column and a column where a person should advise if something passes or fails. The pass fail cell contains a default value e.g.: Select Pass/Fail from the dropdown. When…
-
Copy Row by Automation
I'm copying rows that meet specific criteria from multiple project sheets into a single different sheet using an automation. When looking at the destination sheet, is there an easy way to determine what source sheet each row came from? Similar question for reports - If a report is collecting data from multiple different…