-
Changing Row ID on Comments tab that is exported
Is there a way to change the row ids to a ticket number on exported comments without having to connect it manually?
-
Is it possible to get copies of emails sent out via automation (to a contact in a cell)?
I have an automation that sends out "Congratulations, you passed!" emails based on form submission/sheet data. Is it possible to retrieve copies of these emails that were sent in the past? In case the info is needed, my settings are "unrestricted," and email addresses are from contacts outside of my organization. Thank you!
-
Error message indicating a recipient is not receiving an alert
Hi, We run an automation to alert a Smartsheet group that about a change in a Smartsheet table. Whenever the automation is run we receive an email indicating that particular person (shown by their email address) is not receiving the alert. The person in question has left the company, his email address has been removed from…
-
Connecting two Smartsheets (one a set list of assets, the other freeform)
I am trying to connect two Smartsheets. This is my current setup: The first Smartsheet (Smartsheet A) contains a list of shared assets, designated by an alphanumerical ID. When an issue is identified in one of these assets, it's set up so that when someone clicks the flag button, it notifies others. The second Smartsheet…
-
Linking two sheets
Hi! I have two sheets that need to be related. Some of the colums on sheet 1 have to be copied into sheet 2. The columns that need to be on both sheets don´t follow the same order. How do I link them, so that, when sheet 1 is populated, the info directly populates sheet 2´s selected columns? Thank you
-
Marking Successors Status as "Ready" when the Predecessors Status is changed to "Complete"
I am working with a large sheet and developing an automation to update task statuses: when one task is marked as "Complete," the subsequent task is automatically set to "Ready." While my formulas are functioning correctly on a smaller scale, the size of my new sheet is leading to performance issues. Currently, my sheet is…
-
How are you using Smartsheet's API with the Claude connector integration?
I'm curious to see how others are utilizing Claude Coworks, automations and reviews or otherwise with their Smartsheet in order to work more efficiently alongside the capabilities Smartsheet already houses. I know the answer possibilities are never-ending, so I'm really excited to hear what magic you've all been able to…
-
Sending mails out of office through automation not working
Hi, I am trying to send mails to my vendors through my smartsheet. I have an automation workflow for this. When the value in column "Send Mail" is set to yes, it shall send a mail to people who are added in Supplier Contacts 1 column which is a contact list type. I get a notification saying "Not all recipients will receive…
-
Building a formula based on a check box
Good afternoon. I am trying to solve a problem with our projects (we do not have resource management). for projects that are escalated we have a check box that our managers then see with a report due to the check box. Once the project is back on track, the check box is unchecked and the project goes back to the PM. I want…
-
Status Change within a Cell Formula where it moves it to the next stage if true
Below is what I need in a formula string to generate these items from a dropdown list within the cell. Cancel WT = Yes, Status = Cancelled If Demand Planning/AMT Input Complete (AMT) = True, Status = Finance to Add Cost If Finance Input Complete (Finance) = True, Status = IC to Set Up TO IF TO# (Inventory Control) is not…