-
Best Practice: Intake Sheet & Secondary Sheet when 2-way sync is needed
We're working on a solution for a department that is similar to Uber without the bells and whistles. A call comes in when there's bad weather, a city employee "aka Dispatcher" looks to see who is available in our list of drivers and assigns them to pick the employee up. I think my question is pretty simple? I'm having…
-
Feature request: Hashtags to create automatic reports
Hello! So, the story is: Our team is using a Smartsheet workspace to coordinate the production and deployment of assets of an entire Content and Marketing department. We have created sheets for each type of process/asset (Social Media, Video, Print, Web, Email Marketing, etc), automated formatting in all sheets according…
-
Add Work Insights to Dashboards
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
-
SUM IF / COLLECT / AND all are failing
I have tried several different ways to do what I thought should be a simple calculation. The purpose is to add Hours from one column where the Priority in a second column is either 1, 2, or 3. For perspective there are 300+ rows in the sheet and it grows daily. There are 8 possible priority settings, one is text. I have…
-
Workflow Automation Run History/Log
Is there a way we can see a log of when workflow automations have run, and if there is a recipient for it, then to see which recipient(s) have received it & when?
-
Formula to make a metrics sheet to build a pipleline dashboard
I have a sales tracker sheet and need to continuously pull data as new quotes are formed to show wins/ losses compared to our target in a dashboard. Sheet has 3 columns that need to create the formula: Account type, Weighted Forecast, and Expected Quarter Close. In real words, I want to say Weighted forescast is $1M for…
-
Shared Permissions, sort?
Hi Smartsheet, I think the Shared pop up has changed slightly in the past 3-5 months. How can I sort the Shared users by permission set? I need to reach out to just the group of admins of a specific sheet. Thanks!
-
Owner not able to open newly created worksheets
I just created a new worksheet, where I am the owner of a workspace, and I'm getting this error below. Anyone know why?
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
Permission set sorting
Hi Smartsheet, I'm no longer able to sort the current permissions in my sheets. I need to identify the admins and send them an email, but now I'm forced to sift through the entire listing of shared users to identify which users are admins. Please provide sorting in the user permissions!