How can I enter data in a field that has a column formula?

Renee Dillard

I have a Contact list as a column type on sheet A and it is attached to my feeder sheet B. Sheet A also has a form attached to it and when a list option is selected, the contact list is populated on the sheet. However, if the list option is not selected, then the contact list does not populate.

I need to be able to fill in the contact list for manual entries as well as the automated ones. Is there a way to do this without having to have two separate spreadsheets? Let me know if more information is needed!

KPH

Hi

You cannot enter data into a field that has a column formula but you can amend the formula to check another column and return the value in the other column if the other column is not blank.

Your column formula would be something like this:

IF(ISBLANK([column that you enter manually]@row),original formula,[column that you enter manually]@row)

Hope this helps.

Renee Dillard

I am not sure i understand your suggestion.

maybe it will help if i fill in the gaps. STAFF NAME has a column formula attached to a feeder sheet that pulls the name of the staff member when PROPERTY NAME is selected. I added a column, with a drop down option of "general question or inquiry" so that PROPERTY NAME could be opted out of. However, if PROPERTY NAME is not provided, i still want to assign a STAFF NAME. is there a formula i could use to amend the row in STAFF NAME?