If function based on TBD cells w/3 options
I'm trying to create an email subject line helper cell for my projects. Different project numbers are added throughout my project's life. I start with a VRE#, then later get a Site#, then lastly get a Store#.
Those numbers are always added in that order.
Can you help me write a function for:
If site# and store# are TBD use function in line 10
If site# is TBD use function in line 9
If all 3 are present, use function in row 8
I added a ' in the first column for you to see the functions for each. Hope this makes sense!
Best Answer
-
Got it!
=IF([Site #]@row = "TBD", [Column6]@row + [VRE #]@row + [Column7]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row, (IF([Store #]@row = "TBD", [Site #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row, [Site #]@row + [Column8]@row + [Store #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row)))
Answers
-
This didn't work...
=IF([Store #]@row = "TBD", [Site #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row), IF[Site#]@row = "TBD", [VRE #]@row + [Column8]@row + [Store #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row, [Site #]@row + [Column8]@row + [Store #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row)
-
I think this will get me there. Tying to figure this out now...
Smartsheet IF(OR Learning Center Example....
IF(OR([Due Date]1 > [Due Date]2, [Due Date]1 > [Due Date]3), "Due Date 1 isn't the smallest", "Due Date 1 is the smallest")
Syntax
OR( logical_expression1 [ logical_expression2... ])
- logical_expression1 — An expression that evaluates to either true or false (boolean).
- logical_expression2... —[optional] Additional expressions that evaluate to true or false.
-
IF(OR didn't work.
Maybe I'm looking for:
=IF(logical_expression1, true, (logical_expression2, true), false)
Anyone?
-
Got it!
=IF([Site #]@row = "TBD", [Column6]@row + [VRE #]@row + [Column7]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row, (IF([Store #]@row = "TBD", [Site #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row, [Site #]@row + [Column8]@row + [Store #]@row + " " + City@row + " " + State@row + " " + [Column6]@row + Address@row + [Column7]@row + " " + [Column8]@row)))
-
I'm glad you figured it out! Thanks for sharing your solution and process.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 409 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!