ContributionsMost RecentMost LikesSolutionsFormula helpI need to pull out the text string which in the example below is "MVP623037 (Load ID)" however it is not always in the same place in the field. It could be the first string, second or last string between commas for example. How can I pull this out? Am I also able to only pull out the "MVP623037" in that string via formula? 1381207285 (PRO), MVP623037 (Load ID), MVP623037 (BOL) ------------------------------ Alycn Bjergo-Justen ------------------------------ Cannot add User to subscription reportThis is a registered user with the role/permission to see this data. When I emmulate the user, I can manually go to this report and view it. Why can I not add this user to the subscription? ------------------------------ Alycn Bjergo-Justen ------------------------------Copy Records across TablesIf a user adds a new reecord on a table form - is there a way to have the record or field copy to another table? ------------------------------ Alycn Bjergo-Justen ------------------------------ Re: Formula helpThanks SO much, I think we finally got it to work! ------------------------------ Alycn Bjergo-Justen ------------------------------ Re: Formula helpThank you, this is very difficult. Here is the new error: ------------------------------ Alycn Bjergo-Justen ------------------------------ Re: Formula help ------------------------------ Alycn Bjergo-Justen ------------------------------ Re: Formula helpThanks, how would I make one of those return text if they were NOT blank? ------------------------------ Alycn Bjergo-Justen ------------------------------ Re: Formula help ------------------------------ Alycn Bjergo-Justen ------------------------------ Re: Formula help ------------------------------ Alycn Bjergo-Justen ------------------------------ Formula helpHow can I make a text-formula field with conditions to return Text if another (Date) field is blank? Here is what I tried and have error: (IsNull [ETA Destination Port],"In-Transit"), IsNull [ATA Destination Port],"At Port"), IsNull [Port Pickup Date],"Picked-Up"), IsNull [Empty Return Date],"Empty Returned") ------------------------------ Alycn Bjergo-Justen ------------------------------