ContributionsMost RecentMost LikesSolutionsRe: Formula help for Multi Select Text Thank you, worked perfectly! Formula help for Multi Select Text Hi, I'm looking for help with a formula to display a field that is a Multi Select Test field and if blank display another Multi Select Text field. Example: If [LG Audit] is blank display [Out of Scope]. Is this possible? Thank you in advance. Re: Formula using Contain Thank you! Formula using Contain Hello, I'm trying to count how many records I have that have for Field "Account Name" that contains the work "Wire" and the Field Name "Funding Indicator Name" that contains ASC. I'm not getting an error for the way I did the formula but its not counting when the two fields on a record have the "contains" word. If((Contains([Account Name],"Wire" & Contains([Funding Indicator Name],"ASC"))),1,0) Appreciate any suggestions. Thank you Child table updates and triggers an email from Parent table Not sure if this is possible, but looking for a creative way to trigger an email when a child record is added. BUT the email needs to trigger from the parent record. Parent table: Adds customer information. Connected Child table adds an issue and up to 3 issues can be added.Seebelow: I was hoping that I could get the child record to update "Issue Added" check box on the parent table and I could fire the email off of that. Any suggestions would be greatly appreciated. Thank you ------------------------------ Kathy Benjamin ------------------------------ Re: Counting "Plans" Formula Thank you very much. ------------------------------ Kathy Benjamin ------------------------------ Counting "Plans" Formula I have a field called Plans. (Text Field). I'm trying to write a formula to count how many plans are being audited by an individual each month. The Field Plan can have anything from one plan to many plans. Ex: Plan: A (Answer 1) OR Plan: A,B,C,D,E,F (Answer 6) Thank you in advance for any suggestions. Kathy ------------------------------ Kathy Benjamin ------------------------------ Re: Adding zeros to a text field if less than 7 digits You made my day thank you so much! ------------------------------ Kathy Benjamin ------------------------------ Adding zeros to a text field if less than 7 digits Hi, I have a "Control Number" field that has to be 7 digits. I need to prefill when it is not. See example below I used "1" but it can be any number and I need to make it 7 digits. 1 needs to be 0000001 11 needs to be 0000011 111 needs to be 0000111 1111 needs to be 0001111 11111 needs to be 0011111 111111 needs to be 0111111 Thank you in advance. Kathy ------------------------------ Kathy Benjamin ------------------------------ Re: Concatenate A field based on if a checkbox is checkedThank you. Worked perfectly! ------------------------------ Kathy Benjamin ------------------------------