-
Recommended changes for Resource Manager
I'm trying to plan out a new project today. My goal is to look at the Schedule view and find a Business Consultant, a Project Manager and a Technical Consultant who can work on a project that is 5 months long. The team I allocate need to work on that project till it's delivered so I need a high level view of who is busy.…
-
Conditional Formatting / By User
Adding my thoughts here on Conditional Formatting. Not everyone likes to see "color coding"/conditional formatting on sheets. It would be a great feature to have Conditional Formatting settings by user just like filters. If I set it up only I can see it unless I check the box "Share Conditional Formatting".
-
Dashboard Enhancement - Image for background
Right now, you can only change the colour to the dashboard background to be a solid colour. It would be nice if we can also add background image to the dashboard to either hold all widgets on it or some widgets. So you can section the dashboard with different background to make each section more visible.
-
Conditional Formating on Workflow Emails
As of right now, there is no way for conditional formatting to show on emails that are generated through workflow. I suggest implementing a method to allow this, for example, I have conditional formatting that highlights fields when a specific criterion is met, but when I send that email out via workflow that…
-
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
-
Enable Hourly, Daily, and Weekly triggers when there is custom field in the notification box
Hi Product Management Team: Goal: Send a notification once per day to an assigned individual that includes all the work items (tasks) they've been assigned. Customize the notification so it includes the assignee's name. Problem: When I insert a custom field in the notification customization box like this: Hello {{Assigned…
-
Add a "Strict" Option to Auto Number Columns
The situation is if a row is copied from one sheet to another, the Auto Number unique row ID coming from the source sheet will keep the same auto number on the target sheet. This results in duplicate Auto Numbers potentially, which causes duplicates in what should a column with unique values.
-
Link to a row within the same sheet & have it stay contextual when the sheet is Copied
We can currently hyperlink cells in a sheet to another row. And that row can be in the same sheet or another sheet. 👍️ I would like the additional option when linking to a row in the current sheet, that would allow me to specify whether the link is fixed to the sheet (this is the current situation) or can change if the…
-
Improve Dashboard Visualization when there is no Data for Charts
Hello, I have created some Dashboards for Projects Management Reporting. I added some charts for example to show if there are any Projects asking for Management support, or listing items which are in Red status. When there is no project under that status, the report linked to that Chart shows no data (which is correct) and…
-
Email address for a sheet
Would love to be able to send an email directly to a sheet without using the Outlook Smartsheet plug in. This would enable an outlook rule to automatically send regular emails, such as a daily .csv report from Salesforce, directly to a sheet that would in turn trigger datashuttle.