How do I use a formula in my parent row to update based on the children's status? I want the parent row to to "Active" if any of the children are "Active", "Complete" if all of the children are "Complete, otherwise, "Inactive.
I have some update requests triggered to send to an email in a contact column after a symbol column becomes starred, which is based off of a formula. I have that column turn to a star after it's been 4 days since the date in the "Week Of" column. The dates in that column are always Sundays, and I
New to Smartsheet and trying to figure out the automation aspect - which is what really sold us on the software. So, I have a question - is it possible to send out notifications/alerts based on specific changes within a row? For example I have two tasks - Demo1 and Demo2. I need a
Is there a way to save a date that something occurs? We have rows that get changed constantly, and the status balls change from Green to Red to Yellow to Gray. Any way we can capture the date that a row's status ball changes to Red, even if it later changes to other colors?
If I send an automated alert or update request to someone's inbox, and they reply directly to the email (so they're sending it to automation@smartsheet), who will it go to? I don't see them getting an email from Mailer
I'd like to get a list of unique values in a range. I'm finding a lot on the community about how to flag duplicates, but not sure how to get a list where each unique value appears in a cell. Screenshot below is what I'm looking for. My goal is to incorporate that into a dashboard: I want to see all