-
Sharing Recommendations and Limitations
I'm rolling out a new process with a client and constantly finding areas where I need to use a work around, only to find that solution won't work in another aspect. For example, I have one sheet with sales data that needs to be updated constantly by the sales team, however, I don't want them to have access to the sheet,…
-
INDEX MATCH MATCH to OTHER WORKSHEET
Hi, I'm attempting to perform an INDEX(MATCH(),MATCH()) operation to match the column headers with a row value from another sheet as one would in Excel or Google Sheets. How do I reference the columns as a range and a value? The formula should be as follows: (in cell B2)…
-
Ability to amend 'sent from' email address to personal email for "Email Shared Users"
Regular update notifications are being sent to the Shared Users of a very busy Smartsheet. As such, our client has requested any emails that require immediate attention (not just standard updates) be sent from a personal email account, not Smartsheet. Is there a way to export the Shared Users email information so it can be…
-
Is there a way to migrate external references?
Is there a way to migrate external references from one sheet to another from the 'Sheet Reference Manager' (Right Click Cell -- Manage References... -- Cross Sheet References)? Or would it be a manual task to create references again. Thank you.
-
Activity Log
Is there a way to generate a report from the activity log? What I want to do is to be able to quantify actions being taken within a time frame (i.e.: one month of time). For example, I would like to be able to track how many lines were added to our master sheet - and how many were removed. I would also like to be able to…
-
Dashboard Design - Was the expanded hex palette for chart colors released?
Happy Friday! An expanded hex palette chart with 16M colors was announced at the Engage 2020 Conference (reference Keynote Address). Do you know if (or when) that enhancement will be released? Thanks in advance for knowledge sharing. Edwina -
-
Dashboard Widget Dividers
Is there an easy way to get a diving line or border between widgets on a dashboard? The only thing we've found is to insert images of lines from Powerpoint - not the best.
-
The Mythological Product Development Team
Once again, I have gone in search of what I would consider a perfectly logical and necessary function only to find that Smartsheet can't accommodate. When I call customer service, I receive the same answer every time: “We don’t currently offer that function, but we will submit this to our product development team and they…
-
"Send" row function now requires paid license - no advanced warning
Why were we not informed about this? Copied below is the exact email I received from Smartsheet Product Info on September 17th. This is very frustrating to have a functionality stripped with no warning. We ran through this list with our teams to determine whether or not any of our free users would require an upgrade. This…
-
FEATURE REQUEST - Time Tracking for Project Management
I would love to be able to track time spent on project cumulatively directly in SmartSheets. USE CASE: Frequently we work on multiple projects at once that are time consuming and require multiple actions, i.e. meetings/chat/calls/research/etc./etc. We need to track 15 min chat, 30 min meeting, 60 min research etc. on…
