-
How to automate monthly data from another sheet?
Hi all, Every month, we are required to display new data for review. The problem is that it has to be manually done. I have to login the 1st of the month into the data sheet, copy the data of information that we get from a master sheet, create a new column and paste it there which then is linked to a dashboard with a graph…
-
IF Statement for multiple cells with blanks
I am trying to create an IF statement which returns a status based on the status of 6 separate cells. How do I set the status to ignore blanks from those reference cells? For the attached example, the status should be set to "Not Started" based on the columns highlighted in blue.
-
Alert on Attachment Upload
Is there any way to run an automation or an alert when a file is uploaded to a row? Is there any way to run an automation or alert when a row is missing an attachment? The only work around we've found so far is to put in a check box that must be checked when the file is uploaded, but we are hoping to automate that process…
-
Merged: Automated Workflows Export
This discussion has been merged.
-
Prohibit a cell from being marked as complete
Hi everyone, Does anyone know how you can keep someone from completing a line item? I have a sheet where I ask for a resolution to an issue and some users are marking the item as complete without providing the details of the resolution. I would like to block them from the cell until data is entered into the resolution…
-
Imported Hyperlink Text
We have a project management software that generates the above text representing a job location. We import the text to smartsheet though data shuttle so we can distribute dispatch information to our 300 employees. My problem is that the import works as shown above where the URL is incomplete due I'm guessing to the comma…
-
Converting Workflow Automations into Process Maps
Hi all, Long time listener, first time caller here. I was curious to see if this functionality exists in Smartsheet already or if anyone has figured out a best practice on the following... We have several Smartsheets that are deeply intrenched in workflow automation. As I work on process mapping and documentation for the…
-
Error message when accessing automations in copy of sheet
Hi folks, I have a sheet that has 16 workflows that I'm trying to take a copy of. All the workflows are accessible in the original, but when I take a copy and try to select 'Manage Workflows', I get the following (extremely helpful) message. Another user has tried to take a copy and come up against the same issue. It is…
-
How can a general user tell if a Contact listed on a sheet is a licensed user?
As a paid licensed user WITHOUT Admin privileges, is there a way to tell if a Contact listed on a sheet is a licensed user (free or paid) vs someone manually entered? Use case: Automations allow messages to be sent to "Limited" users in the same account or "Unrestricted" any email referenced. However, all contacts visually…
-
dropdown list dinamics or smart
buenas tardes! me seria de gran utilidad si alguno ha conseguido actualizar el listado de valores de la dropdown list con valores obtenidos de otra hoja.. desde ya agradezco y me seria muy util Gracias
