-
RYG formula for indicating expense vs. budget
Hi, I am trying to use RYG balls to indicate how much remains in a budget (red indicates 90% spent, Yellow indicates 75% spent) Using this formula, I get green and yellow, but I can't seem to get red, even though there are expense/budget over 90% =IF(Charged14 / [Budget Allocated]14 > 0.75, "Yellow", IF(Charged14 / [Budget…
-
If with multiple criteria along with VLookup
I am looking to use an "If" statement with multiple criteria combined with a VLookup. Within the formula below, I want the result to be blank if the Vlookup result is any of the terms I have specified, if it does not match, I want the Vlookup result to stand. =IF(OR(VLOOKUP([Row ID]26, {Bookkeeper List}, 2, false) =…
-
Determining Exact Match for Multiple Criteria in a Multiple Selection Dropdown
I am trying to grade a quiz where the answers were submitted via a smartsheet form. I am having trouble figuring out how to confirm that there is an exact match on questions that had multiple answers needing to be selected to be considered correct. On questions that only use one answer, this is the formula I use:…
-
Connecting End Date or Duration from Jira to Smartsheet
I understand that I cannot bring over the end date from Jira to Smartsheet when there is dependencies/ one directional. Does anyone have a tip to use a duration field in Jira to populate the end date in Smartsheet? Or any other way to get an end date in Smartsheet from Jira? I have dependencies enabled in Smartsheet and I…
-
Return Work Dates between start date and end date
Hi, I have 2 columns, [Start Date] and [End Date] on my sheet. I want to fill another column [All Dates] with all dates between and included start and end date. So if: Start Date - 8/24/2020, End Date - 8/28/2020, i would like the return values in a column [All Dates] to be: 8/24/2020, 8/25/2020, 8/26/2020, 8/27/2020,…
-
Reduction of Column Count from dynamic form
Has anyone found a way to reduce the column count from a long dynamic form? I was thinking of using conditional logic on a separate form with a copy workflow to move data, but I'm not confident it would be reliable. I'm running some tests now, but if anyone already has a solution I would be very happy to hear about it.
-
How can I get the contact information to update when there are changes to the reference sheet?
I have an Assessment sheet where contacts are auto assigned using a match Match/Index formula. I have updated the reference sheet with a different contact, but that change is not reflecting in the Assessment sheet. Is there an additional step I need to take to get this to refresh?
-
Formula to Forecast Material Quantity Received vs Consumed
I am hoping there is a formula to see what I will need to forecast to purchase for material received vs consumed. Any help would be greatly appreciated!
-
Auto-Alphabetizing Drop Down Options
I'd like for the drop-down and filter options to auto-alphabetize after a user enters or edits the options. Currently, the options stay in the same order they were entered in, so I either need to alphabetize them in my head or outside of the platform for a more readable experience.
-
Multiple IF, AND, NOT, & ISBLANK functions
I'm trying to create different status text to appear based on multiple criteria. I'm looking for specific cells to contain text to signify that a review process has reached that level. I've created a descending order If/And function that includes multiple "NOT(ISBLANK" functions to determine which cell is blank, thus…
