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 b…
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 …
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: …
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 th…
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 colum…
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: d…
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 pr…
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 c…
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 upgra…
Is there a way to have all automation generated notifications for user 1 be temporarily transferred to user 2 when user 1 is on vacation? We can do it by changing each automation workflow but this is …
