ContributionsMost RecentMost LikesSolutionsRe: Duration FormulaHello Jamie, For calculating simple duration, We have "Formula - Duration" as field type available in Quickbase. Few changes required here are : Change field type of "Days Open/Advisor Actively worked" to formula - duration. Formula Modification :- If([Status]="Complete", [Date Completed] - [Date Advisor Received] , Today() - [Date Advisor Received]) The 1st Date Client Advisor Received comes back with error Field not identified. - this is because in your formula you have two square brackets instead of one. Hope it resolves your problem. Looking to hear back from you! ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------ Re: Color-coding a field returns field nameUse below formula to apply color : If([Age Formula]>3,"<div style=\"background-color:red;\">"&[Age Formula]&"</div>",ToText([Age Formula])) ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------ Re: Hiding the Save&Close buttonYes, you can use "&ifv=1" in url at last. Example : URLRoot() & "db/" & [_DBID_] & "?a=er&rid=" & [Record ID#] & "&ifv=1" ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------ Re: Formula Text Field - Buckets based on DurationHi, use below code : If([Penetration Days]<Days(0),"Not Aged", [Penetration Days]>Days(1),"0-3 M", [Penetration Days]>Days(91),"4-6 M", [Penetration Days]>Days(181),"7-9 M", [Penetration Days]>Days(271),"10-12 M", [Penetration Days]>Days(366),"13-18 M", [Penetration Days]>Days(547),"19+ M" ) You need to remove the comma after text in last line. ------------------------------ Pranav Choudhary Quickbase Expert Builder Certified by Quickbase beniwalpranav@gmail.com ------------------------------ Re: Formula to Save & New while keeping fields from current record You can use Save & new option from dropdown at top right while adding record. Data can be passed from fields 15, 7 and 9 to new record by using relationship and creating any one of those which has unique value as reference proxy and other two as lookup fields. So anytime Add record button is clicked then 15,7,9 will be auto populated on new record on basis of reference proxy key. ------------------------------ Pranav Choudhary beniwalpranav@gmail.com ------------------------------ Re: De-Duplicate Data in a Text Field.Thanks Mark. It was really helpful. ------------------------------ Pranav Choudhary ------------------------------ De-Duplicate Data in a Text Field.I am bringing data into a Formula-Text field from another table using formula query function. Now, data has entries separated by ";" and I want only distinct entries to be displayed. For Example : ABC;DEF;DEF;GHI;DEF;ABC are the entries and I want only ABC;DEF;GHI as output. My data has more than 20 entries so bringing it in as multi-select text doesn't fits. If I Split the entries on basis of ; and collects them in Multi-Select Text and use summary field to display it in parent table then problem is solved but then again Multi-Select Text allows only 20 entries and I have more than that so Summary field only summarise from those 20. Please advise some way. Thank you. ------------------------------ Pranav Choudhary ------------------------------Solved