Lose data and dropdown list when I apply a column formula

edited 10/06/22 in Formulas and Functions

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...


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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!