# Need a formula to populate one cell based on the data in another cell.

Options
✭✭✭✭

For the columns shown below, I need to populate text in the Status Phase column based on the number in the Pipeline Phase column. 3 = Launched, 4 = Active, 5 = Closeout

I have searched and used the following two formulas based on similar questions by other users.

=IF([Pipeline Phase]@row = 3, “Launched”, IF([Pipeline Phase]@row = 4, “Active”, IF([Pipeline Phase]@row = 5, “Closeout”, “Blank”)))

Neither have worked and return UNPARSEABLE as shown in the screen shot.

Any assistance would be greatly appreciated.

Delilah

• ✭✭✭✭✭✭
Options

Hi @Delilah,

If your Pipeline phase is only ever numbers (nothing extra), then this should work for you:

=IF([Pipeline phase]@row = 3, "Launched", IF([Pipeline phase]@row = 4, "Active", IF([Pipeline phase]@row = 5, "Closeout", "")))

It will give the results you want for 3,4 & 5 and come up blank otherwise.

Your formula has AND in, but only a single condition so this isn't required.

Hope this helps, but if you have any problems/questions then just post!

• ✭✭✭✭✭✭
Options

Hi @Delilah,

If your Pipeline phase is only ever numbers (nothing extra), then this should work for you:

=IF([Pipeline phase]@row = 3, "Launched", IF([Pipeline phase]@row = 4, "Active", IF([Pipeline phase]@row = 5, "Closeout", "")))

It will give the results you want for 3,4 & 5 and come up blank otherwise.

Your formula has AND in, but only a single condition so this isn't required.

Hope this helps, but if you have any problems/questions then just post!

• ✭✭✭✭
Options

That worked! Thanks very much.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!