-
Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??
Hello beautiful community of SmartSheets, The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that…
-
Update Request Automation has stopped working
I have an automation set up to send an Update request for when a row changes, to an email address inputted on the row. It has been working for a while, and still works for most email addresses, but for some reason has now stopped working for just a few emails. Is there a reason for this? Settings have been checked and all…
-
Import Data from Database
Good day, I am looking for a solution that will allow me to automatically populate a Process Owner column in Smartsheet from an Oracle table (for example). From what I have been able to find, the Live Data Connector is not capable of importing data from a Database to Smartsheet (It can go the other way, which in this case,…
-
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…
-
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…