I am trying to have a create a few conditional formulas or triggers and I am missing the logical argument somewhere. I am trying to get cells in Column J to automatically enter “All Sources” if the selection in Column F is “Term” 

I am using Data Validation on most columns and rows in this form, but these are automatic selections regardless of the remainder of the information. 

I am not sure if this is best served by a rule, conditional formatting, a formula, or some other option that my brain is skipping. Thank you in advance for any guidance. 

​I am trying to have a create a few conditional formulas or triggers and I am missing the logical argument somewhere. I am trying to get cells in Column J to automatically enter “All Sources” if the selection in Column F is “Term”  I am using Data Validation on most columns and rows in this form, but these are automatic selections regardless of the remainder of the information. I am not sure if this is best served by a rule, conditional formatting, a formula, or some other option that my brain is skipping. Thank you in advance for any guidance.   Read More

​