-
Form Entry Metrics by Category
I'm creating a metrics sheet that will have data input by external parties via a form. I'm trying to think of a simpler/more user friendly way to display categories on the sheet and form. There are many category options and I need the # of occurrences entered for each category to tabulate monthly metrics. Most of these…
-
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…
-
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?
-
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!
-
Freeze Column issue
Good afternoon, We have a Freeze set to maintain the view of a certain columns that are referred to throughout the day. However, the freeze doesn't actually work as expected, as almost every time I go into our sheet the pane has been moved either direction which defeats the purpose of keeping certain columns visible at all…