-
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…
-
Forward automation notifications when on vacation
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 not a good solution. Thank you, Neil
-
How can the name of the approver auto populate into "approved by"?
We have a change order request form for our suppliers to use when requested a change in the design or scope of our projects. I have an automatic workflow to send the request for approval to our construction manager(s). When they approve (or deny) the request, the status changes to approved (or denied) .. but I cannot seem…
-
Entry date/Payments
I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in May. How do I make it so that the sheet won't calculate until the "entry date"?
-
Recurring Tasks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
-
Auto number risk column only adding till row 20 to another sheet reference
Dear reader, I came across a unique issue and need a help. I created a 'portfolio sheet' with list of projects in one column and a next column for Risk ID with text single line I created a separate sheet 'Risk register' with a dropdown of all the projects similar to the portfolio list and added a Risk ID column with #Auto…
-
Why Portfolio Summary Sheet displaying duplicate rows?
I created a blueprint in Control Center and all was working fine until I updated some columns (adding more values for drop-down list and changing a column to a formula column) in the intake sheet. I think I must of done something that messed up the blueprint because now new provision projects are showing up twice on the…
-
Automate create email that won't immediately send
I'm wondering if it's possible to do something similar to what excel does, where we can program a button that once pressed creates an email with a specific template but won't send until clicking send like a normal email. The idea is that it would populate an email template based off the information in my Smartsheet to…
