Trending in Formulas and Functions
Revise Formula - RYG
I am using this formula: =IF(OR(CONTAINS("Insert Word", [Column 2]@row), [Column 1]@row = 1), "Green", "Red") However, I need to revise it so that when column 3 (which is an additional column not mentioned in the original formula) contains a specific word, it changes my ball to yellow.
Row # on Another Sheet
Hey! First thanks in advance for looking. Is it possible to get the row # on another sheet? I want to know the Row # for New: Release Update Sheet. New: Release Update Sheet Release (would require Is Parent to be checked) Row ID (Auto Number) Release List (This sheet is where the formula would go) Releases Auto (Auto…
Can you add a Sheet name to a formula?
Can you include the sheet name in a formula? Not reference the Sheet. The Sheet is already referenced in the INDEX/MATCH formula. I could manually add the sheet name to the formula, but wondering if it's possible for the formula to automatically pick up on the Sheet name.