Need a formula to populate one cell based on the data in another cell.
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
-
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
-
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!
-
That worked! Thanks very much.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 410 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!