Hello! I apologize for what may be a newbie question. I am currently trying to figure out if this is possible:
Under the single select option for Community, is it possible to set up conditional logic that automatically populates another column with either “remote” or “rural” depending on which community was selected? So far, we have been populating this column manually, but I would love to know if it can be automated.
Thank you!
+27You have a couple options:
Communities and define which communities are rural/remote there, and uses a LinkToAnotherRecord field for {Community} instead of a SingleSelect field with a Lookup field for {Status} instead of a SingleSelect field.{Status} into a Formula field using IF() or SWITCH(). The formula will depend on how many communities you have, and how many potential “statuses” there are.
+21@Kamille_Parks offers some great suggestions. To answer your original question, it’s not possible to directly have one field drive another field using logic; e.g. a formula field can’t determine what option appears in a single select field. It’s also not possible to add logic arbitrarily to any field type (much to the chagrin of many). Fields are either manual entry—single line text, single select, date, etc.—or calculated —formula, lookup, rollup, etc. They can’t be both.
You have a couple options:
Communities and define which communities are rural/remote there, and uses a LinkToAnotherRecord field for {Community} instead of a SingleSelect field with a Lookup field for {Status} instead of a SingleSelect field.{Status} into a Formula field using IF() or SWITCH(). The formula will depend on how many communities you have, and how many potential “statuses” there are.Thank you so much! The solution is so much more simpler than I’d thought. I clearly have a lot to learn still! This works perfectly.
@Kamille_Parks offers some great suggestions. To answer your original question, it’s not possible to directly have one field drive another field using logic; e.g. a formula field can’t determine what option appears in a single select field. It’s also not possible to add logic arbitrarily to any field type (much to the chagrin of many). Fields are either manual entry—single line text, single select, date, etc.—or calculated —formula, lookup, rollup, etc. They can’t be both.
Thank you so much for your explanation! This is helpful!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.