Forum Discussion
Custom Column return value based on two other columns
Hi, Hoping y'all can help me. Basically i want to create a custom column that picks up a value from Column 3 based on whether Column 1 and Column 2 contains something. Essentially the custom column...
You will have to replace the empty/blank cells in Column2 with null, but then you can use this expression
= if [Column1] = null and [Column2] <> null then [Column3] else null
Pat
You will have to replace the empty/blank cells in Column2 with null, but then you can use this expression
= if [Column1] = null and [Column2] <> null then [Column3] else null
Pat
Thank you Pat 🙂