I have setup a ticket tracking sheet where anyone in the organization can enter the trouble ticket via a form. I have required that the requestor put in their email address. I would like to setup the Workflow so that when the ticket number is added then the Requestor gets an email to notify them the Ticket Number and that…
I have set up an initial intake form which gives the choice to go to another form: one form or the other depends what they want, e.g. request a report or request access to a file. With either form, the filled out request goes to the same smartsheet that captures the request regardless which form they use under the column…
I want to calculate the number of days that a ticket is in Backlog. [Ticket Status]@row = "Backlog" WORKDAY([Date Submitted]@row, TODAY()) is the number of days from the date of submission to current date. I realize that my Date Submitted cell sometimes is blank so I added: NOT(ISBLANK([Date Submitted@row]) check. Now it…
