MarkGlevickyQrew Cadet6 years agoFormula for a report - text triggers numberI have a column in a report that I want to put a report formula column next to. The initial column contains text and I want the formula column to put a numeric value based on the text in the first co...Show More
LauraThackerQrew Captain6 years agoThis is how you write a Contains() statement for your situation: If(Contains([WRO],"W"),5,If(Contains([WRO],"R"),1,null))
Related ContentCreate a formula duration over 5 yearsLooking for State abbreviation to full spelling formulaReport Formula - Strikethrough TextReport Formula'sReport Formulas
Recent DiscussionsAre all QB notifications "No-Reply" emailsBulk create child records from selection listSolvedSelecting which fields to display from Formula URL searchesHelp Needed with Quickbase Pipeline to Accumulate Values Instead of OverwritingSave & Redirect in a Formula URL Using API_GenAddRecordForm