Formula to Select Multiple Dropdown Options using Two-Column Criteria
Hello,
I am looking to be able to auto-populate the pending permits based on the empty date cells where we input our received dates.
I currently have to manually choose what permits are missing, but am hoping there is a formula I can use to show both missing permits. Below is what it currently looks like and after that is what I'd like it to look like using a formula to generate the two permits missing on the row in the same cell.
I may need to add in a third if missing a Special Permit.
Best Answer
-
=IF([Town Pole]@row <>"","Town Pole Permit")+" "+IF([State Pole]@row <>"","State Pole Permit")+" "+IF(And([Special Permits]@row<>"",[Special Permits]@row<>"N/A"),"Special Permit")
There is no functionality to use a multi select option in a formula. How ever you can do text.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Answers
-
=IF([Town Pole]@row <>"","Town Pole Permit")+" "+IF([State Pole]@row <>"","State Pole Permit")+" "+IF(And([Special Permits]@row<>"",[Special Permits]@row<>"N/A"),"Special Permit")
There is no functionality to use a multi select option in a formula. How ever you can do text.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
That worked! I tweaked it a bit and got rid of the "AND" where I don't want to count the N/A and the additional Special Permits section. I never would have gotten that one. Thank you!
-
your very welcome. I did the special permits part just in case you wanted to add that into it maybe at a later point.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!