-
Moving Sheet Template with links to blueprint into another Workspaces
if you move a template from one workspace to another, would you lose the links associated to the blueprint?? I know you need to be an owner to be able to move the templates to another workspace but all the links associated to the data sheet fill in the blueprint, so if I move it to another workspace, then would I lose…
-
Separating Items from Dropdown List
Once you've selected multiple values from a dropdown list and they all go into a single cell, is there any way to separate the values in the cell out into individual rows in another sheet?
-
Separating Dropdown List
Once you've selected multiple values from a dropdown list and they all go into a single cell, is there any way to separate the values in the cell out into individual rows in another sheet?
-
Transferring ownership on workspace
Hello I recently transferred ownership to a workspace to someone else. While the workspace list him as the new owner, the items in that workspace (sheets, reports, dashboards, etc.) still have me as the owner. Do I have to transfer each item within the workspace or is there an easier way? Thanks Cris
-
IF condition and a blank cell.
I need the formula to work when the cell its reading is blank. =IF(MONTH([Closing Date]@row) = 1, "January", IF(MONTH([Closing Date]@row) = 2, "February", IF(MONTH([Closing Date]@row) = 3, "March", IF(MONTH([Closing Date]@row) = 4, "April", IF(MONTH([Closing Date]@row) = 5, "May", IF(MONTH([Closing Date]@row) = 6, "June",…
-
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…
-
Keep the colour of the cell when you link it out to another sheet
Hello, How can I keep the colour of the source cell when I either link it out to another sheet - I have tried the simple "Link from Cell in Other Sheet..." and also a Vlook up but the colour doesn't come with the text Any solution please? Thank you Karne
-
Calendar view
I've automated a vacation request form; and I see Calendar view in smartsheet, however it only shows the first day instead of all days when the employee is out of the office. Is there a way to show all days in the calendar view that the employee will be out? Thanks.
-
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…
-
Basic Unparseable error
Hi, I'm really confused as to why I can't do a simple COUNTIF. I'm trying to create a summary sheet for a dashboard and simply want to count the amount of "discovery" from a dropdown column. Anyone have any ideas? Thanks Dan =COUNTIF({1 - Sales Pipeline Status Range}"Discovery")
