-
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!
-
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.
-
Resource Allocation in Parent Rows
Does Smartsheet allow resource loading parent rows? I am trying to assign parent rows to staff and allocate percentage on the parent row, but it does not allow allocation entry on the parent row. I do have resources enabled on the sheet. I do not want the parent row to sum the allocation percentage of the child rows.…
-
Need a workaround so Parent Rows stay children rows when sorting
As I understand it, Smart sheet does not have the function to keep parent rows with children on reports like on the filter function. Which baffles me! Is there a work around that anyone can recommend for our situation? We currently have a Ready@Spike Date column. This will indicate when each child row will be completed.…
-
2 week task for 2 hours each day
Is it possible to have a task with a duration of say 2 weeks, but only allocate a fraction of the day’s hours to the assigned resource? For example, John Smith is assigned Qlik development that will last for 2 weeks, but will only be developing for 2 hours/day. I know it’s possible to change the default length of a day…
-
Community Platform
Did Smartsheet develop the software running on the "Community" or did you purchase collaborative software? If you purchased the software, can you tell what program is being used. I find the Community and how it functions to be very good.
-
Automating RYG balls based on Due date and completion status
Im having an issues creating this formula and was hoping someone could help improve on my formula. Im trying to create a HEALTH flag marked "Green" if the task is not due today, "Yellow" if the task is due today, and "Red" if the task is past due. However, the HEALTH flag should stay blank if: 1) the STATUS…
-
Smartsheet and the Elusive Roadmap
Dear Smartsheet users, A few months ago, we made the decision to remove our public roadmap, which has caused frustration for many of you, particularly in our Smartsheet Community. We removed the roadmap for a few reasons - as priorities and resources change, we couldn’t give the expectation that the roadmap was set in…
-
Appsheet
I am meeting with management and IT on Friday to persuade them to use appsheet with our Smartsheet data. I know appsheet is one of the approved integrations but is there any other documentation from Smartsheet that could help make the case for this?
-
How to manage Order with multiple items
I'm creating a form to collect Order information from users and facing a difficulty with an order having multiple items. I want to create a form which allows users to input multiple items in one order request. Each item will have each price and quantity. How can I do that in smartsheet? Thanks.
