-
Quantity in cell to rows
Hello, I have a column named "Quantity" and the cells of that column, I have numbers (any number). Is there a formula or a function that can create new rows (specifically of the quantity) in that sheet or another sheet automatically? Is that something this is automate-able? Example: If cell A1 in Sheet 1, has a quantity of…
-
VLOOKUP Reference Vacation Calendar to Update Approver via Automated Workflow
Hi, I have an employee Vacation Planner sheet with a status column/formula that indicates whether an individual is currently on "PTO" based on today's date and whether it falls in the range of their vacation's start and end date. In a separate Smartsheet, we will be managing service tickets and certain types of requests…
-
Automation - One Email Per Trigger
Hello, I have got a very basic sheet setup where my co-workers submit a request via form, and when it drops into my sheet I have rudimentary automation set up to email me "when triggered". This all works fine and dandy. However, if someone submits multiple lines in quick succession, I get multiple lines wrapped into a…
-
Notification except if attachment are available
I want to be able to automate notification to certain users in case a row is modified, but only if this row does not have an attachment. How can I do it? I tried adding a condition to the trigger for notification, but the field "attachment" is not there, so I can't put a condition on the presence/absence of attachment. Any…
-
Request for new functionality: Automated entry of cell-completer
Hi, I love the new automation features (e.g. automated entry of dates into a column). I would really benefit from similar automation for population of a column for the cell-completer (i.e. the person who made an entry into a cell). The flow would be similar to this: Automation is set up and enabled John Smith makes entry…
-
Health status formulas and automation
Hi, is anybody able to help with automation formulas for the Health column? I'm very new to Smartsheet and struggling a bit! I'm trying to do the following: Green - Status='In Progress' and more than 1 week before end date, or status= 'Complete' Yellow - Status= 'In Progress' but end date 1 week away Red- Start date is…
-
Inconsistency with copy row automation
Hello! I am running into some issues when attempting to utilize a copy row automation. Sometimes the rows are copied to another sheet, and sometimes they're not. Here's a breakdown of my process... Sheet 1- approval workflow is automated upon form submission, records a date when approval is granted Sheet 2- utilizes a…
-
approval automation sending multiple emails
I have a smartsheet with a couple automation rules set up to email PM's about submittals. My "request an update" rule runs nicely and sends a single email to the PM with MULTIPLE requests when they click the form in the email. However, my "request an approval" email sends a single email for EACH item to be approved, which…
-
Getting attachment when attachment is added or changed to a row.
I dont know much of programming and I am not a developer. But I would really like to get attachments from a row in Smartsheet. Posibly automated, so when attachemnt is added or changed in a row, this triggers API. I was looking for a simpler way to do this, either directly with smartsheet, or with a third app like Zapier.…
-
Health of Task or Project using % Complete & Finish Date - Sanity Check
I found something close to what I am looking for here: NEED HELP: Health Formula based on start date, end date, and %100 complete needed. — Smartsheet Community This formula doe s a great job of flagging the dates in relation to time left. However, I am looking for a health check that can take into account both percentage…
