Formula to Add Text based on Series
Hello,
I am trying to find a formula that will allow me use the series column and then return text in the approved column.
EX: if series is B, or L I want the Approver column to return RSM. If the Series column is S or K want the approver to be CE. I have hit a brick wall in figuring this out.
Answers
-
Hello @Nicole Forleades
Try:
=IF(OR(Series@row="B",Series@row="L"),"RSM",IF(OR(Series@row="S",Series@row="K"),"CE"))
Melissa Yamada
melissa@insightfulsheets.com
Data made simple, spreadsheets reimagined
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!