Hello,
On picture "actiondeck"(blue) when I select the "no" form control option box in Row 8, it makes cell "R8"=2 an dbecause of that makes cell "P8" Red.
What I am trying to do: is that when "R8" equals the value 2 or 1 then it will report the question number("1") in the next available row of "Column D" of picture "actiondeck2"
-it would also report the name of the "sheet" of "actiondeck" in "column d" in the same row.
I am then trying to report the "Action Item" number (Column B of "actiondeck2") of the row to cell "S8" of "actiondeck"
Please let me know if you need any clarifications because i understand this may sound confusing. thank you.
On picture "actiondeck"(blue) when I select the "no" form control option box in Row 8, it makes cell "R8"=2 an dbecause of that makes cell "P8" Red.
What I am trying to do: is that when "R8" equals the value 2 or 1 then it will report the question number("1") in the next available row of "Column D" of picture "actiondeck2"
-it would also report the name of the "sheet" of "actiondeck" in "column d" in the same row.
I am then trying to report the "Action Item" number (Column B of "actiondeck2") of the row to cell "S8" of "actiondeck"
Please let me know if you need any clarifications because i understand this may sound confusing. thank you.