-
Automatic reminders based on dates
Hi All, very new to smartsheet so please be kind :) I have a requirement whereby I need to badger suppliers to ensure that they will deliver on schedule, so I'm hoping to do the following: Add a column for expected delivery date Add a tickbox for "will require chasing" Have a reminder automatically set to trigger at 50% of…
-
SmartSheet scheduling during non-working days
With Memorial Day approaching, I noticed that I have project work scheduled on 29 May. I checked the project settings, and 05/29/17 is listed in "Non-Working Days (holidays, exceptions). I used the calendar tool to remove and re-add the date, but I still have work scheduled on the 29th. I assume there's a simple solution…
-
Approvals process
How would we notify the person submitting a request that their request was declined?
-
Resource View Possible?
I'm setting up a Sight/Dashboard for the team of engineers. I like how the Resource View shows each sheet someone is assigned to under their name, with a link to the sheet for more info. My goal is to incorporate that into the dashboard/sight view Is there a way I can achieve this for a without having to update it…
-
Comments - Adding Pictures
It would be useful if we could add pictures to the discussions/comments. I am a CPA and I need collaborate reporting review and we currently communicate through email because of the quick ability to add in snipits/screenshots. I know attachments can be uploaded but I would prefer to have the picture embedded in the…
-
Manufacturing Scanning
We manufacture an industrial machine. As the system moves through the process at each station we would like to update the status of each machine with a qr code or a barcode, and trigger automation rules ie send emails or alert for issues if they come up. We want in the future to populate the smartsheet with info from…
-
Compare two dates and apply conditional formatting
I have two columns of forecasted dates UTILITY and IN SERVICE. When the UTILITY date is past the IN SERVICE date I want both cells hilighted. For example if UTILITY = 9/30/17 and IN SERVICE = 5/10/17, I want both cells to be red. I understand That I'll have to use a third column to base the formatting from but I cannot get…
-
Time Tracking integration with TimeCamp
Hi all, It was recommended a while ago that we use integration with TimeCamp to track our time because SmartSheet does not have that capability (and boy do we wish it did!). TimeCamp seems to be able to synchronize with SmartSheet and pulls all the tasks for a project if the are in the primary column. Our employees track…
-
Project Time Tracking
Good morning, Does Smartsheet have, or plan to add, a timer feature for deliverables? Currently our project leads track their time manually or use programs such as the Outlook journal. I would like a feature in Smartsheet where a user can start a timer on a row and the duration would update each time a user starts and…
-
Epic to story issues from Jira
Hey all, I recetnly created a workflow with smartsheet and jira. All the issues seem to be imported with the stories under its respective epic indented. Later, when i linked some issues to its epic in jira and then refresh smartsheet i dont see those stories to get automatically indented under its epic. Do i have to do it…
