-
VLOOKUP for a range of numbers
Hi Community, I am looking to try and do a VLOOKUP against a range of numbers versus a single value. The function as I know it today only allows you to look up a value and pull the corresponding value for it (i.e., If the color is Green, then put 2 or if the color is Red, then put the number 3) In my use case, I am looking…
-
Populate Start and End Dates with Today based on status
My sheet has Start Date, End Date and Status columns My formula in Start Date is =IF(Status@row = "In Progress", TODAY()) My formula in End Date is =IF(Status@row = "Complete", TODAY()) My problem is the date values disappear when the status changes. How can I make the Start and End Date values stick once the field is…
-
Counting values in a multi-select column when "Yes" in another column?
I'm trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out. This one ALMOST works, but it won't count when another value is selected in the multi-select:…
-
VLOOKUP to Return Formula?
How can I use a VLOOKUP to return a formula instead of a string? How should that formula appear on the source sheet? I've tried putting it in quotations then extracting with FIND, but no luck.
-
Formula for "Overdue" in Status Column
I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line. i've read a lot of the other posts but none of the formulas seem to apply or work when I input them. Please let me know your thoughts. Thank you!
-
Formula for RYGG symbol based on RYGG symbols in 6 other columns
balls. The 6 other subcategories/column names are: * Financial Status * Quality Status * Staffing Status * Delivery/Operations Status * Customer Satisfaction Status * Subcontractor Management Status The Overall Status is green if all subcategories are green. The Overall Status is yellow if 1-3 subcategories are yellow. The…
-
put current date when checkboxes are checked
Hello, I want to configure a formula to set the current date when 2 checkboxes are checked. I have configured 1 date column and 2 checkboxes columns. I don't want to use the auto-modify date column for this purpose. Please help.
-
Auto assign based on value in Field
I would like to auto assign and update the Assigned To field based on a value in another field. I've tried something like this; IF([Contract Type]=NDA, John Doe) So if Contract Type equals NDA, then put John Doe in the Assigned To field otherwise keep blank. Can someone assist?
-
Ignore Parent Records formula & Ranked graph
Hello. I am trying to create a graph that shows the top 10 tasks ranked by the variance between Initial Duration and Actual Duration. To make this work, I want to ignore tasks that are parent records. What would this formula look like? I have created a formula to rank the Variance; =RANKEQ(Variance1, Variance:Variance, 1).…
-
Dates in formula AVERAGEIF
Hello, I have problem with the dates in the formula below (in sheet summary) =AVERAGEIF([Date of request]:[Date of request], >07.01.2019, [Completed in days]:[Completed in days]) The Smartsheet returns me the value 0 that is wrong cause I have lots of numbers that meet this criterion. Please advise and thanks in advance