-
Auto-assign sequenced number to new project(s) sheet
Is there a way to automatically assign a uniquely sequenced ID# to each newly created project sheet? We'd like to do this for/across a group of users that collaborates on short-termed projects (3-6 mos). Basically have the application assign a unique and automatically sequenced ID# for each new project. Thanks in advance.
-
Alerts and Notifications not working
I am running an evaluation of Smartsheet. I have turned on Alerts (right away) so that Supt. can get notification whenever there is a change on a sheet. Those alert notifications are not be being sent out. I have tested it several times by updating the % Complete (yes I have that one as part of the alert). But the changes…
-
What data is sent to Zapier on the updated row trigger?
Hi, I want to send a custom email with data of a row when some of its cells are updated. The recipient of the email is in a column of the row. I try to do it with Zapier using the "Updated row" trigger but it seems that the data sent to Zapier is all the sheet and not only the row. Has anyone faced this? How could I only…
-
User Acceptance Test Script Template
Has anyone created a user acceptance test script in Smartsheet before? If so would you be willing to share the template with me?
-
Links in templates that can create a link on creation to a set sheet
I have a request that may already be possible so if someone can assist would be great. If not possible I believe it would be a great new feature.! We create a new sheet for each of our manufacturing jobs from a template. When this new sheet is created we then have to copy link the first row of the job sheet into a WIP…
-
Best way to report a top of funnel of requests metric
Hello, We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing this is to pull a report that looks at the created date and 7 days back, but I know you…
-
Formula does not always recognize "" for blanks?
I have an odd one that hopefully someone can shed light on as i am going a bit crazy :) I finally figured out a formula i have been working on for few days ... strangest thing it seems to have been the quotes that i was using ??.... I used the quotes (directly to the left of the enter key with shift ) as a blank and i…
-
Change Control Automation for I.T.
I would like to create and automatic a change control process for I.T. As the VP MIS I want workflow with control criterias build in based on the change requested. E.G. if its a level 1 or a critical system or downtime etc. It would come to me. E.g. if it's an update or level 2. I can go to my I.T. manager. Is that posible…
-
Formulas Across/Within Sheets
Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The column information and email address are both included in sheet 1. I have tried many…
-
Resource management - split task
Hello, I have a question. Is there a possibility to split a task? for example, I have a task with 4 days duration and this task will be assigned to a person. He is working 5 days a week, but the 3rd day he has a day off (task 'day off'). Is there an easy way to split the task to monday, tuesday, thursday and friday? Thank…
