-
Revert to Single-User Contact Column from Multi-User Contact
Hello, Experimenting with the new Multi-User Contact Column, I've found out the hard way that it is treated as a separated Column Type. In other words, when running a report I need to have check 2 "Assigned To" columns. I went back to the Sheet that had the "Allow multiple contacts per cell" checkbox checked... and looks…
-
Adding new workspaces to an existing report
Hi Smartsheet community! I have a workspace that we frequently "save as" for new projects. The format, columns, etc - stay the same for every workspace, every project. Is there a way for my new workspaces to be automatically added to my roll-up report automatically? Please?
-
Exporting Excel formulas
I noticed that formulas, even simple formulas are not exported to a Excel. I have a big smartsheet where we created butcket that has additions per row (summarized) and we noticed that they're not exported as formulas in Excel. It's a shame because we have to start over in Excel an create template and data again. Is there…
-
Building sheets that talk to each other
Hello, I have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work. I basically want one sheet that our shipping team updates to automatically update another sheet my purchasing team uses. The columns have dates and check boxes so when…
-
Return Multipe Cells
Hi Smartsheet community, I have the following columns: [Name] (text/number value) [Team] (drop down value) [Budget Milestone] (checkbox) [Program Milestone] (checkbox) [Project Milestone] (checkbox) Now I am unable to run a report because the what in report builder condition is either all 'OR' or all 'AND', not all tasks…
-
Horizontal Axis Maximum Range
Does anyone know how to alter the horizontal axis range? I have a chart that is displaying percentages but the horizontal axis maximum percent is set to 120% so pieces of the project are looking as though they are not complete. I tried stretching the chart out and making it smaller, nothing works. In excel you usually have…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
Web content and google sheets - instructions don't work out
I've been trying to update a dashboard to include the new Web Content widget since I find managing some data and charts in Google Sheets far easier than in Smartsheet especially when collaborating on the data / file. I've followed along with the instructions for the Google chart I've created. Publish > Embed > and copy…
-
@Mentions needs login
If I mention someone in the comments, does the collaborator need to login and be shared to be notified or even notified without an account, as with updates requests?
-
Web Content Widgets
Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?