-
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…
-
Syncing data between sheets
I don't have access data shuttle. I have an automation to copy information from one master sheet to another. I need the information from sheet #1, when various cells are updated, to sync information to sheet #2 without "copying" or "moving" rows. thank you for your help in advance.
-
Recover Deleted Columns
One of my licensed users deleted two columns. Is there a way to recover these ? The activity log does not help as it just states that the were deleted. The next activity shows that the formulas were unparesable with details which doesn't help with the original data. Help?