Larry
Larry
Reactions
-
Re: If Formula Help: =IF X symbol and X symbol are X, display X in this column
=IF(AND([Impact on Stakeholder]@row = "High", [Stakeholder Influence]@row = "Low"), "Weekly") You can continue the IF(AND( logic to handle all combinations1 · -
Re: How to get the same name from two different sheets to populate a third cell based off their response
@Brandon Eschman please be sure to tag me as I do not get a notification otherwise. =INDEX({Check-Up Submissions Range 1}, MATCH([Name]@row, {Check-Up Submissions Range 4}, 0)) I believe I incorrectl…1 · -
Re: COUNTIF formula help
=COUNTIF([Issues]:[Issues], CONTAINS("Red", @cell))1 · -
Re: COUNTIF formula help
Happy to help. The @cell functionality was new to me at first, but it is super helpful when you need to establish a range in an argument of the formula prior to establishing the logic argument. In th…2 · -
Re: Checkbox for Unique Item Name
Oh I see, my mistake. I adjusted your original formula & missed the "first instance" issue. You will need to add an Auto # column like I have done in the screenshot.I generally just tit…1 ·
