Can If-Then formula populate Primary column?

I need to populate the information in the primary column from a dropdown menu but cannot because of the type of column. If I place a column next to it with the dropdown information, can I use an If-Then formula such as =IF(ISTEXT([Client name drop down list]1), "Text", "Not Text") where I change the "Text" to equal whatever text is actually populated into the field?

Find more posts tagged with

Formulas

Support

Cell linking

Comments

Jeff K.

Yes, as long as the final output is a text or number.

I do it all the time to merge my proj. task numbers with the task name and another team's task number (if available).

Pam Tadsen

That's great, thank you! When I use the formula in my original query, however, it merely populates the primary column cell with the word "text" rather than the text of the cell next to it. (Basically, I want it to copy the information that appears in the adjoining cell.)

Pam Tadsen

Okay, sometimes I overthink things. What I finally figured out was formulas101... if I just use this formula =[Client name drop down list]1 - the cell in the primary column copies the exact information in the column next door (where the drop down information resides). Doh!