-
Help Desk Ticketing with alerts that can be generated at 4 and 8 hours
We have just onboarded a customer that we want to track their IT service tickets using Smartsheet. There are two key Service Level Agreements that we need to managed to. The customer would like automated alerts generated at 4 and 8 hours. Is there a way to set up alerts based on hours vs. days? Thank you!
-
New tabbing organization for many summary levels
When I have 5+ levels of hierarchy in the tabbing, the tabbing doesn't seem to suffice to show organization and I cannot understand the hierarchy from just viewing the tabs I have tried using highlights but I have too many sections and subsections to have distinct highlight colors. My solution is to make brackets on the…
-
Using predecessors to dictate duration
Hello, I have a line in a sheet that I would like to start when another line starts and end when a different line ends. For example, I have 4 lines in a sheet: Line A, Line B, Line C, Line D. I want Line A to begin when Line B begins and end when Line D ends. I want the duration to be malleable and change automatically if…
-
Conditional formatting for all children?
Hi, we principally use smartsheets to generate Gantt charts for our various projects. Ideally we would like to set up conditional formatting (for example task-bar color) for all of the children of different parents. So for example, let's say "Phase 1" of a project is the parent, we would like an easy way to have the…
-
Docusign Integration Requirements
Hello all! I am building an app using Smart Sheets and will need to integrate it with Docusign. I am not able to find which version of Docusign to purchase. I've downloaded a free trial to test but when I attempt to login it, I don't get connected. Can anyone address my question or point me in the right direction? Thanks,…
-
Help converting and excel formula to smartsheet
Hi everyone, I'm pretty new to smartsheet so I may be asking your help for something that is quite easy to do :) I have an excel formula that I need to migrate to smartsheet to help me transform seconds in HH:MM:SS The excel formula is =TEXT(IF(I4="";50;I4)/(24*60*60);"hh:mm:ss") & ":00" Is there a way to use the same…
-
Impact with Urgency equals Priority
Hi, I am looking into utilizing a ITIL related priority matrix approach to populate a Priority. The Priority levels column's cell would have values P1, P2, P3, P4, P5. The formula needed in the Priority column would output an appropriate priority level based on specified combination of values from two other columns: Impact…
-
Automated Alerts & Actions
OH MY! You all are so close... I've been waiting on the day that I could save my alerts and notifications to a template for over a year now. On average, I create about 10 new sheets every week, and each sheet consists of 2 REMINDERS and 8 NOTIFICATIONS. We use these sheets to track new parts to be manufactured, and once we…
-
Checked and unchecked box
I need the amount from 1 column to appear in another column if the box between both columns are checked. Please write out the formula so I can copy and paste. Please see the attachment. Greatly appreciated.
-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
