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

Best Answer

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    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!

Answers

  • Nick Korna
    Nick Korna ✭✭✭✭✭✭
    Answer ✓
    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!

  • Delilah
    Delilah ✭✭✭✭
    Options

    That worked! Thanks very much.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!