-
RYG formula question
I need some help with tweaking the below: =IF(OR([Actual Completion Percentage %]@row = 1, [Schedule Variance]@row >= 0.9, AND([Actual Completion Percentage %]@row >= 0, [Baseline Start]@row > TODAY())), "Green", IF(OR([Schedule Variance]@row >= 0.8, IF(OR([Schedule Variance]@row < 0.9, AND([Baseline Start]@row < TODAY(),…
-
Is there a way to change the date that Work Insights goes off of?
Right now work insights creates the date ranges based off the creation date of the row itself. This is not conducive for what I am trying to accomplish. I have a separate column for "Hired Date" that I want to be able to sort the data from Work Insights. Is there anyway to change what dates Work Insights uses in your sheet?
-
How do I extract the last line from a cell?
Hello! I am trying to extract the last line from a cell and place it in a new column marked as "Current Status." Ideally, I want "This vendor is going to be retired by Nov 2022." in the Current Status column. I can do this in excel using the below formula. any help is appreciated. thank you!…
-
Index Match Formula
Hi everyone! I am trying to use the Index / Match formula to display data from different sheets into one. But I am having trouble getting it to match, I enter the formula as below but I keep getting no match. =INDEX({Johnson Range 1}, MATCH([Task Name]@row, {Johnson Range 2}, 0)) Any help would be much appreciated!
-
Totaling Columns with Children
I have tried but cannot find a formula to add the total of the items in yellow and calculate the total at the red arrow.
-
nested formula help
Hi, I've tried multiple variations of this formula and cant seem to get it to work. If high level status is "inactive" and detailed status is "abandoned", then turn the patent status column to say A If high level status is "inactive" and detailed status is "closed", then turn the patent status column to say A If high level…
-
IF AND formula to determine number of days
Hi team - I imported this Excel spreadsheet but the formulas aren't the same in Smartsheet so I need help. So in the encircled cell the Excel formula reads: =IF(AND(T2<>"",U2=""),DAYS(AC2,T2),"") T column = DD Kick Off Date U column = Date DDQ sent to TP AC column = Today's Date I need a Smartsheet formula that states: if…
-
Count Children Criteria Out of Totals
Smartsheet Community: I am Trying Create a Formula That Will Count The Total Number of Children That Pass Out of the Entire Population Set. For Example: 10 Out of 300 Test Cases Passed My Formula: =COUNTIF(CHILDREN()), "Pass" + " Passed Out Of " + (COUNT(CHILDREN(), " ") + " Pass") Thanks
-
Creating a Customer Form with multiple selections without having to create 70 columns.
Hi, I'm creating a form that will be sent to our customer base, which allows them to select their franchise, which will auto populate their list of stores to select from. I am trying to do so without having to create 70 different columns. I've previously created items similar to this with the vlookup tool and another grid,…
-
VLOOKUP IF "Column B" Is Blank
Hi, I'd like to do a vlookup If Column B is blank, than vlookup, if it contains any value, Copy that value here in this cell. Is that possible? Thank you!