ContributionsMost RecentMost LikesSolutionsRe: Formula modifying an existing set up numbers Thanks Mark! And my team thanks you too! :) ------------------------------ Jamie Strauss ------------------------------ Re: Formula modifying an existing set up numbers Mark! Worked like a charm!! Thank you so much! Now, any ideas on how to export it so excel doesn't drop all of the zeros? ------------------------------ Jamie Strauss ------------------------------ Re: Formula modifying an existing set up numbers THANK YOU! It's ALMOST working! But right at the end, $FirstFour & $LastFive is highlighted saying a number was expected but found text. Maybe I need to change the field type? I have formula numeric ------------------------------ Jamie Strauss ------------------------------ Formula modifying an existing set up numbers Hi Everyone, I have a formula I am trying to find but I'm losing hope. I need to remove a decimal in a string of numbers and reformat in a specific way. Regardless of the original length, I need to reduce the numbers to a total of 9. The first four are whole numbers and the last 5 are decimals. The desired out-come: 2.18 = 000218000 46.71428571 = 004671428 163.5 = 016350000 10.9 = 001090000 I currently have a team manually updating 812 records which is not efficient at all. There has got to be a better way, I just can't figure it out. Again, I'm not sure automating via a formula is possible but wanted to pick everyone's respective brains. ------------------------------ Jamie Strauss ------------------------------ Silly Formula Question AlertI am still learning formulas in quickbase and I wanted to write one that I thought was easy, but my brain is making it difficult. Set Up: Advisor multi select field (field 12) There are currently 10 Advisors I want to hard code a formula (not use filters) to pull a report that displays only the projects the 3 out of 10 people are working on. Am I making this to difficult because nothing works. I don't want to use the filter function because it's limited ------------------------------ Jamie Strauss ------------------------------ Re: Duration FormulaWorked like a charm! Thank you so much :) ------------------------------ Jamie Strauss ------------------------------ Duration FormulaHelp! While fairly new to "fun" with formulas, I am trying to calculate a simple duration. I've got field "Date Advisor Received" and "Date Completed" Both are Date Type fields. I've added another field "Days Open/Advisor Actively worked" Formula Numeric I'd like the days to calculate when the Date Completed Field is not populated. My formula: IF([Status]="Complete", ToDate([[Date Client Advisor Received]]) - ToDate([[Date Completed]]) , Today() - ToDate([[Date Client Advisor Received]]) The 1st Date Client Advisor Received comes back with error Field not identified. HELP please! ------------------------------ Jamie Strauss ------------------------------