Action to Copy From [Key] Column Having Condition ([Type] =“Yes”)
To Column [New Key] to ALL Selected ROWS
Any Idea How to Achieve This Result?
Action of type Data: set the values of some columns in this table, column New Key, value LOOKUP("Yes", "MyTable", "Type", "Key").
I Tried Your Formula
It is Setting Same Value Every Time
I have More than One Yes in That Column
I Want to Copy Valve From Selected Column Having Value “Yes”
Amit_Jain:
It is Setting Same Value Every Time
That’s what you indicated you wanted, so that’s what I provided.
Amit_Jain:
I have More than One Yes in That Column
You didn’t say that originally and there was no way for me to know that.
Amit_Jain:
I Want to Copy Valve From Selected Column Having Value “Yes”
There is no simple solution for that.
Any Other Solution?
Anyone Can help me with This Issue?