-
Moving Rows between sheets
Hi! I have a Original sheet with data being inputted by different users and locations. I was trying to build out reporting so I moved one locations data to another sheet. Is there any way to move it back to the original so I can change it to copy rows to the secondary sheet instead? I don't want to risk losing all the…
-
Need Help With Setting Up Automation
I can't get this automation to work. I need the Final Approval Box to change to "completed" when all 6 previous columns have the appropriate answers. "Approved" needs to be in the approval columns (3 total) and the sign off columns (3 total) need to contain a text or not be blank. These 6 columns will be filled out by 3…
-
RYGG ball and task status formula based on % complete and due date
Hello! I am working on a column formula for a project plan where the RYGG ball and Task Status will automatically be updated based on the % complete and the due date. What I'm trying to solve for is: if % complete = 0 and start date is today or in the future, then stage is grey and status is "not started" if % complete =…
-
Auto populating Rows based on the number in the Qty box
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…
-
Alert Someone Notification Failing
Good afternoon, I created a sheet that includes an automation to "alert someone". It is configured to send an email to two distribution lists at 8am when the date is 1 day before the date of the column "Date Arriving" in this sheet. The automation works perfectly when using my Smartsheet login's email as the one being…
-
Start date for alert - send on the last Wednesday of every month
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…
-
Automation Email Alert Issue - Grouping Notifications with Unique Subjects
Hi everyone, I've been experiencing an issue with an automation setup and was hoping to get some insights or solutions from the community. Problem When I configure automation to send an email alert to a contact after a trigger change, the system groups email notifications together even though each has a unique value in the…
-
Automate Linked Cells
I have an issue that I've seen in other discussions but I have not been able to figure it out for my situation. I want to automate the process of linking cells from one smartsheet to others. I will provide as much information as possible below. - We have a master sheet, "Project Dashboard" with about 15 columns where I…
-
How to send an automation to multiple contacts in another sheet?
Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and the content is not always static as people change roles (email x may be changed to email y tomorrow). Sheet B has an automation to request an update when a row is updated. How does Sheet B sent the…
-
Smartsheet Expert
Hello, My name is Caylee Birkel; we have a cabinet design company in Nebraska that uses Business Smartsheet everyday and need help taking our Smartsheet needs to the next level. We don't want to upgrade our plan to anything higher than our existing plan. If you feel you can be of any assistance, we would love to hear from…
