Lose data and dropdown list when I apply a column formula
I have a working cell formula that takes the parent value and adds it to the cell:
=IF( COUNT(PARENT()) = 0, "", PARENT() )
But when I apply this as a Column Formula, it wipes all existing cell data in the column and also restricts the ability to use the Dropdown List column type function.
I thought I could change the formula to only work if a cell is blank, like so...
=IF(ISBLANK(), IF(COUNT(PARENT()) = 0, "", PARENT()),0)
But this formula triggers an
#INCORRECT ARGUMENT SET error.
Question: How do I use the 1st formula as a column formula, without:
- wiping existing data?
- removing the ability to use the dropdown list?
- only trigger when a column cell is blank?
Help Article Resources
Check out the Formula Handbook template!