-
Use a Filter to hide/show/reorder columns? (Like a SQL "view")
Hi there, Is it possible to do something similar to a SQL "view" with a sheet? I see that I can create named Filters, but these only let me change which Rows appear -- not which Columns (and not in what order). It'd be very useful to have multiple "views" of a data set that could be targeted to different audiences who need…
-
Adding Formulas to Predecessors Column...Or Is there a Workaround?
Hi there, Okay, so here's what I'm trying to do. Our team is using a smartsheet schedule and within that schedule, is a bunch of sub-schedules, that all work together in glorious harmony :) Up until now, I've been able to use the Predecessors column with ease, for e.g. 1FS + 5d, meaning that the project on the 2nd row will…
-
SmartsheetGOV integration for Microsoft Teams?
Hi there, The integration with MS Teams looks awesome! Unfortunately, it doesn't appear to be available for "gov" customers. Is there a roadmap for implementing that integration? Thanks! Jamie
-
Smartsheet to Word Document
One of the ways, we utilize Smartsheet it is track the publications that come out of research. A few times a year, we are required to report on all publications and they need to be formatted in a specific way. Is there an option to transform a row into a Word friendly version v. the information being in row format.…
-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Copying Workspaces with Dashboards
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Currently we have to go into each dashboard and update the links - very tedious. We are using…
-
Published User issue
The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tracked. How do I tell who this "published user" is, and why isn't the user's nme listed instead?
-
Counting criteria from a multiple drop-down column across multiple sheets
Hello, I'd like to show the number of tasks each person on my team is working on in a roll-up sheet. On all my project sheets, the 'Assigned To' column allows multiple names. When I attempt to aggregate the number of times a name appears in this column on all the referenced sheets, I get an incorrect number (no formula…