-
How can I compare two lists for overlap?
Hello, I'm trying to compare the values in two multi-selection dropdown lists to see if there's any overlap. Say both of them have options (a, b, c, d, e), and List 1 contains (b, c) and List 2 contains (c, d). Is there a way to return True because they both contain (c)? The larger goal is using this to add a contact to…
-
I am looking to create a formula that counts the avg number of days issues go past due per Depts.
I have a column calculating days past due for each row and a column categorizing each issue to a department. Now I am wanting to combine this information and calculate the average number of days that issues are going past due per each department. For example, all rows with Finance in the Department column will have their…
-
How to make a number less than 0 show up as 0
I am trying to calculate the number of working days remaining in a project plan, but if the end date is in the past it is showing negative numbers. How do I change this to show a 0 instead of the negative number if the task is complete? This is the current formula I am using: =IF(ISERROR(NETWORKDAYS(TODAY(), [End…
-
How to use index/match on multiselect dropdown list?
I am working on launching a global hiring form that uses this formula: =IFERROR(IF(Country@row = INDEX({Approved Seats Country}, MATCH([Unique Seat Code]@row, {Approved Seats Unique Seat Code}, 0)), 0, 1), 2) Basically this formula returns the number "1" by searching for the name of the country in the source sheet…
-
How can you count someone assigned to a cell if there are multiple people assigned in the same cell
Im using a metrics sheet to show home many people have RYGB symbols. However, there are some rows that have more that one person assigned to the task and it will not count their symbol if this is the case. Is there a formula that can count even if there is more than one person in the "ball in court" column?
-
Change Status and Health when % Complete is updated
Hi- I'm struggling with trying to automatically change my status and health columns depending on date changes. Is the following do-able? If % complete is = to 100% then status turns to "Complete" and my health symbol turns blue If % complete is < 100% and my Finish date is greater than 7 days then status turns to "In…
-
Time Indication and DATEONLY function
Hello, I have a few questions below regarding Smartsheet: We're utilizing Smartsheet to track start time and end time in a 24-hour clock to count the duration of some of the tasks we complete. How can I remove the time in "Created", I would only like to have the date. (photo 2) Question 1 Explanation below: I've noticed…
-
Copy/Move Row Automated Workflow Not Working
Hi there, I have two very basic workflows set up - when the "status" column of a row in one sheet is changed to "review", I want that row to be copied to another sheet. The second workflow is the exact same, but when "status" is changed to "complete" I want that row to be moved to another sheet. The workflows are not…
-
Summary Sheet History
I have a summary sheet for my smartsheets. It contains several fields, including 3 fields that are updated weekly manually. I'd like to create an automated way to save the values of these manual fields ( Date, text, text ) so I can refer to them for historical purposes and evaluations. I can't find any way to do this. Any…
-
Generate a Report by using sheet summary
I'd like to generate a report that shows : Which tasks are in progress ( Including their parent ) which tasks are at risk ( Defined by tasks that were supposed to be started but are not started yet ) and it should show their parent as well. One of the problems I have is that under a given milestone, there can be several…
