-
How to count the times a person is assigned to a defect status
Objective: Have dashboard that reflects defect status and who is assigned to it, if blank then "Not Assigned" Example 1 Jake has three defects assigned to him. 2 = "Intake" 1 = "Vendor In Process" Example 2 Eric has 5 assigned to him 1 = "Resolved"; 3 = "Ready for Retest"; 1 = "In Process"; For any defects not assigned,…
-
Closest Date in the Past
Hi, I am currently building a ranking that I will display in a Dashboard. I need to grab data from another sheet that is the closest in the past to keep it up to date. Any suggestions for a formula?
-
Check if a date is within multiple ranges
Hi there, I'm trying to figure out whether I could write a formula to check if a given date is within multiple ranges. Concretely, I have two sheets: One where I book people's time to work on specific tasks Another where I keep track of people's holidays What I would like is to get an error message if I try to book Yann…
-
Formula Multi Select in Dynamic View
Hi, I have a column where someone enters a multi-select list from a form of missing documents. Someone will then track down those documents and delete them from the multi-select cell until all documents are found and the cell is blank. I want to be able to track which documents were missing though. So I made a formula to…
-
Automatic Linear Percentage Complete Formula
Hello, I am wondering if you can help. I currently use Smartsheet for project planning. I would like to build an automatic percentage complete formula. This formula should work off a linear progression line from Actual Start Date to Baseline Finish Date and the duration. So an example of a task would be: Actual Start: Now…
-
Eliminating "0" from a cell when it is returned in a formula
Hi, In order to get some downstream formulas to work, I am trying to remove "0" from my calculation cells if "0" is the result. Based on the reported success with the formula other Community posts, I have tried to use this approach: =IF(original formula > 0, original formula) ...by using this sheet-specific formula:…
-
Formula for Quantifying Importance based on Priority Level and Due Date
Hello, I am looking to create a formula to help prioritizing tasks based on importance and due date. I assigned a value for the priority level as: =SUM(IF(Priority@row = "High", 6, (IF(Priority@row = "Medium", 4, (IF(Priority@row = "Low", 2)))))) + ______ The second part of the equation I need to have based on due date. I…
-
Cross Sheet References
Hi, We have a data entry sheet where data is entered via forms and an overview sheet, that is an overview sheet with cross sheet references. Using sumif formulas, however this only works when you open and save the overview sheet, you can't get live data unless you open and save the overview. Any workaround to this?
-
Help with SUMIF Formula
Hey Community, I need some assistance with a SUMIF formula. I am trying to say, Multiply Column 1 by Column 2 IF Column 1 is greater than 1, if not, leave blank. I have tried several different ways but all keep coming back #UNPARSEABLE. Would appreciate some help with this. Thank you in advance!
-
Smartsheet count function
I'm using the count function to count how many times a initial appears in a line and its working great except it won't count a line that has multiple initials in it. Does anyone know how to get it to count that line?