-
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…
-
Share sheet as a copy - Consolidation
Hello everyone, Starting with Smartsheet, I don't find any documentation about distributing a new and unique sheet to collaborators. The idea is : * I build a main spreadsheet, and I want multiple collaborators to fill this sheet individually * I want to keep track of all the status of certain indicators for each…
-
ERP System
Can someone please advise if Smartsheet links with an ERP system? Is there one software that is more recommended with others? I did see that there are some integrations with ERP ( Acumatica, Meisterplan, etc). Are there others that I may be missing? Please advise thank you!
