-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Combining If/then with date population
I am trying to figure out a way to auto-populate a date, but only IF a specific condition is met. (Screenshot below) I used the formula =WORKDAY([1st Test Date] 1,6) to auto-populate the "Second Test Scheduling Date", but I would like this to only auto-populate if the column "1st Test Results" is "Positive". Any tips? I'm…
-
Mail Merge with Form
Hi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. With those results, later on, i must issue a document to the customer with those same…
-
Scroll bars only work when mouse is on top of them in Chrome
In Chrome, the scroll bar works when you manually drag it but does not work while using the mouse. The manual dragging is a reasonable workaround but would be nice to be able to use the scroll around on the sheet without the scroll bar. This scrolling is not an issue in Firefox or Explorer.
-
Dashboard automatic updates
Hello, I am looking for a way to send a weekly message to a group of shared users to view the team's portfolio dashboard. Currently I have a scheduled report that is sent weekly, I want to do the same with the dashboard. Thanks Michelle
-
Combining a Nested IF Formula and Searching for the First 4 Numbers in a String
Hello Smartsheet Community, I am trying to build a Nested IF formula to assign a site name depending on the first 4 numbers in the screening participant ID. So for example, I would want the formula to identify "S401" from the string "S401001" in the Screening ID Column and assign the name of "01/New York" in the Site…
-
Medical Publication Tracking- what is best template to start?
Hello, Any insight to the best Template or Template Sets to use to initiate: --basic tracking for medical publications (ie, manuscript development; congress abstracts & posters & presentations) --with "at risk" elements; or Red, Yellow, Green notifications Thanks!
-
Credentialing Tracking with Smartsheet
Looking to setup credentialing system and database with smartsheet. For instance, submitting application, tracking, approvals, expiration dates. Any ideas or format to setup the system will be appreciated. Thank you
-
CAPA - Industry Standards (benchmarking)
I am in the Medical Device industry. I am looking for some bench marking information around what a well rounded CAPA system Metric should look like. For example: What is the typical percentage of CAPA types in your CAPA System. For example: Random numbers here: 78% Corrective 14% Preventive 7% Internal Audit Corrections 0%…