-
Update Parent Row based on Child status
Hi! I want the Parent row to automatically change with the most recent Child Row status. I currently do this manually so I have to update the status in 2 different rows. Right now I have this: =IF(COUNTIFS(CHILDREN(), "Open") > 0, "Open", IF(COUNTIFS(CHILDREN(), "In Progress") > 0, "In Progress", IF(COUNTIFS(CHILDREN(),…
-
#UNPARSEABLE using COUNTIF for text objects
I have a Form which allows the recipient to answer a question via a drop down list: Example: Where would you like to go for vacation? List includes: U.S., Europe, Asia, Australia It's a pick many list so users can select any number of answers. The resulting cell then may contain something like: U.S. Europe Asia I would…
-
Index, Match, Max, Collect
I am trying to use the following formula to identify the name of the last Manager in Training (MIT) to graduate their training program with a certain Mentor, but wherever there are instances of MITs having the same graduation date, the formula is returning the wrong MIT for the given Mentor, and I cannot figure out why.…
-
How can i get a group of information to autopopulate by selecting a dropdown?
Hello, I am trying to figure out how i can get 5 or more different rows to auto populate from selecting one dropdown. when I select a dropdown for example 48-3, I want it to fill out the 3 columns like the above pic. This is for a manufacturing schedule, it is all the parts needed to make the product (48-3). including…
-
Report Gantt formatting is not showing in the dashboard
Hey All, First time post. I looked through some keyword searches for my problem, but didn't find this specific issue. I am rolling up all my projects into a high level filtered report and formatting the Gantt for my directors using the following settings: Everything looks great: However, when I pull this specific report to…
-
Ability to amend 'sent from' email address to personal email for "Email Shared Users"
Regular update notifications are being sent to the Shared Users of a very busy Smartsheet. As such, our client has requested any emails that require immediate attention (not just standard updates) be sent from a personal email account, not Smartsheet. Is there a way to export the Shared Users email information so it can be…
-
Is there a way to migrate external references?
Is there a way to migrate external references from one sheet to another from the 'Sheet Reference Manager' (Right Click Cell -- Manage References... -- Cross Sheet References)? Or would it be a manual task to create references again. Thank you.
-
Activity Log
Is there a way to generate a report from the activity log? What I want to do is to be able to quantify actions being taken within a time frame (i.e.: one month of time). For example, I would like to be able to track how many lines were added to our master sheet - and how many were removed. I would also like to be able to…
-
Sheets exiting folders overnight
Hi all! Wondering if anyone else has this problem. I have all of my sheets organized nicely in folders. Many of the sheets are shared (but not at the folder-level). Some days, I log on in the morning and everything is as I left it: Some days, I log in and some of my sheets have decided to sneak out of their folders into my…