Formula help
I looking for a formula that do the following:
If column A displays the first 6 numbers (this has 8 possibilities), and column E is of $50 or < value, display a given name, if column E is of $50.01 or display a given name. Thanks in advance.
Answers
-
@BT Brown I don't really understand your criterion, can you be more specific? What numbers? What name? Do you only care if Column E is exactly $50.01 and not more than $50? What happens if that number is exactly $50? Where are you displaying this?
-
Thanks Eric,
I will try to be more detailed:
I would like Column E to only display certain criteria in a drop list when certain criteria are met.
Column A
if column contains any of these numbers 433062, 454830, 425426
Column E
If column E contains a value of $50.00 and/or More
Column Y
will only display 123.456 in the drop down
There will be other criteria, I just looking for a way to get this formula started. I believe the formula will in the Y Column, but not sure how to begin this.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!