-
Possible to close Comments window using a keyboard shortcut?
Does anyone know it the Comments window can be closed using a keyboard shortcut or are we required to click on the 'X' icon in the top-right corner?
-
Capturing Email Responses
I would love and really need to capability to for Smartsheet to capture responses to emails in the comments. Example if a user sends a document for comments through SmartSheet email as users reply back I would want to see those replies in the comments. Rather than having to log into smart sheet leave a comment and then…
-
Power Bi dashboards?
Hi Community i'd be interested to know how useful members are finding the Smartsheet linkage with Power BI to create some excellent Graphical dashbards possibly as a supplement to the more Numerical View achieved in Sights? Could any of you describe your Use case? Could you describe how easy or Difficult it was to set up?…
-
format row with color on date
i have two columns, one is today date collumn and other is review date coloum , if my review date was 20-12-2016 and it today date is 21-12-2016, and it expired i want full row colour changed format and receive reminder setup. thanks you
-
Change the size of Harvey Balls
Hi SS Users! Just wondering if there is a way to increase the size of my harvey balls? I have a sheet being pulled into a report, and then being displayed into a Sight. The harvey ball appears on the Sight, but looks ridiculous becuase it is soooo small. Is there a way to increase its size? Ive tried to change it in both…
-
How do I automate an import data from CSV so that I get service tickets for my team based on priorit
Hi All: I would like integration of our Helpdesk system with a Smartsheet file (i.e. Team Task List by Priority template). The Helpdesk system is our database of service tickets that my team will need to work on and resolve. Having the capabilities of Smartsheet such as team sharing, update requests, and card view would…
-
Autofill Capabilities based off of Dropdown selections?
When selecting from a dropdown menu, can you build corresponding autofill capabilities into the next cell? I have a dropdown list of classifications that correspond to a weighting system. I'd like to be able to select a specific classification and have the following weight cell autopopulate. Is that possible through a…
-
Scheduling resources (internal & external) without a Project Plan
I am working with a client (outside construction with internal and external resources) who wants to create and maintain a scheduling workspace/tool. Presently, they assign work in teams against various initiatives and urgent work orders. The goal is to ensure all resources are fully utilized and work is prioritized. When a…
-
Number of years/month between TODAY and a given date not working
NEw trial user ;^) Have a very basic calculation. From a Purchase Date I would like to calculate the number of Years and Months that have passed since purchase date from TODAY. Two fields: Purchase Date: Date Age: calculated difference of TODAY() - Purchase Date. But each forumula comes back #unparaseable. But most work in…
-
COUNTIFS on the same column
Hi, I'm trying to create a formula, which runs a count on a particular column e.g. 'Status' column, with values of 'In Progress', 'Build' and 'QA'. I would like to find the total number of projects that have a status of: 'In Progress' and 'Build' I'm using the COUNTIFS formula, however no luck so far. Any ideas would be…