ContributionsMost RecentMost LikesSolutionsRe: Formula needed to pull out most recent status of a logged multiple choice field Mark, as crazy as that looks it worked like a charm! Thank you! It pulled the most recent Status only with no dashes or spaces. Re: Formula needed to pull out most recent status of a logged multiple choice field Don, that was close. But it pulled out the oldest status, not the most recent status, with a space before it. Formula needed to pull out most recent status of a logged multiple choice field I have a multiple choice field, PICC Request Status, that is also a logged field. Most recent choices are at the top and on their own line. Trim(Right([PICC Request Status],"]")) pulls out the first logged status with the dashes: --------------Needs Review The current field contains -- [MAY-13-25 Molly Smith] -------------- Closed -- [MAY-12-25 Molly Smith] -------------- Action In Progress -- [MAY-12-25 Molly Smith] -------------- In Review -- [MAY-12-25 Molly Smith] -------------- Needs Review The end result of the formula should just be Closed. What do I need to adjust in my formula? SolvedHow to build a pipeline that creates child records based on a list-user field in the parent record? I have 3 tables - Projects, Tasks, and Task Bids. In the parent table, Projects, I have an embedded Tasks table that is editable on the Projects record so managers can just fill in the tasks they need completed. On that embedded Tasks table I have a list-user field where they can assign up to 20 contractors. When I save the Project (which will also save the Tasks) how can I build a pipeline to create separate Task Bid records for each contractor on the list-user field? Re: Still no way to remove all users from user field? I found an easier way to do this because I have too many users as well. If you click on one name, hold down the Shift key, scroll down and click on the final name (you have to leave at least one name) and they will all be highlighted. Then click the Remove User button. Worked like a charm for me! Re: Conditional formula url You are correct, Mark - it was a user field and that solution worked perfectly. Thank you!!! Conditional formula url I'm trying to build a conditional url formula where if a multiple choice field equals a certain person, display this url. Unfortunately, it's not pulling in anything. Here is my current syntax in the formula URL field: If(ToText([Contractor Operations Manager])="Sally Struthers","https://calendly.com/sally.struthers") & If(ToText([Contractor Operations Manager])="Fred Flinstone","https://calendly.com/fred-flinstone") Any thoughts? SolvedRe: Looking for formula checkbox to check if a record was created in the first 5 days of the current month That worked Gary! Thank you!! ------------------------------ Dawn Rene ------------------------------ Looking for formula checkbox to check if a record was created in the first 5 days of the current month I need to figure out a checkbox formula to check if a record was created within the first 5 days of the current month using [Date Created]. Any suggestions? ------------------------------ Dawn Rene ------------------------------ Re: Is there a way to add a line break to a text field directly in the pipeline Thank you! That worked! ------------------------------ Dawn Rene ------------------------------