# Formulas & functions

## Conversations

Recent Conversations
Conversations 16 - 30 of 2927
###### Dynamic form rules don't work correctly
The Otherwise - supposedly lets me know what's going to happen. But it doesn't work. When I preview - and make changes to the field that...
• 1 me too
• 8 replies
• Question
• In Progress
###### Formula to Generate Which week of the year it is based on date entered in "Process Date" Field.
In search of Formula to Generate Which week of the year it is based on date entered in "Process Date" Field. I tried one and it is tellin...
• 1 me too
• 14 replies
• Question
###### Countdown formula problem
I have a date field that will be some date in the future (field is titled "Publication Date") and I want QB to tell me how many days ther...
• 1 me too
• 2 replies
• Question
###### How to calculate the number of months between 2 dates
Simply, I need a formula to calculate the number of months a vehicle has been in service.  I have a [In Service Date].  So I am thinking ...
• 1 me too
• 2 replies
• Question
###### Filter report based on user and field content
Hello: Working on another challenge.  Just a formula formatting issue: I have created a report I have created for Accounting Personnel....
• 1 me too
• Question
• In Progress
###### Elapsed days invoice aging
Well.... having some "developmental opportunities" again. Trying to calculate days an invoice is aging after being sent (believe it or n...
• 1 me too
• 4 replies
• Question
###### Conditional Dropdowns Dependent on Multiple Many to Many Relationships
I am attempting to solve for something which I believe can be solved natively. I'm looking to pull in information for "Rates" for a produ...
• 1 me too
• Question
• In Progress
###### Formula to check box based on duration result
I am trying to create a checkbox formula field [Time to Appt <=7 days] that would check the box IF the duration field[Time to Appt] is <=...
• 1 me too
• 2 replies
• Question
###### Is there an option that can create a color coded Map (US) report?
Currently, I'm tracking products based on their availability within each US State. It would be nice to have some sort of visual map repor...
• 1 me too
• Question
• In Progress
###### What is the "Remove" option in Report Filter Criteria?
I recently went into update an old report and noticed there was this "Remove" function in the Initial Filter criteria (see photo below in...
• 1 me too
• 2 replies
• Question
###### Can you create a calculated column in a Summary Report that uses other columns in the report to generate the final column?
I have two columns in a summary report that I would like to generate the third column. The first column is Total Moves, the second column...
• 1 me too
• 3 replies
• Question
• In Progress
###### Formula Text to format JSON for webhook
I'm trying to make a JSON webhook sendinblue and for the emails to use I use a formula text that grabs all the emails related and formats...
• 1 me too
• 5 replies
• Question
• In Progress
###### need to identify and eliminate duplicate records from combination of 2 different fields in a report
I have two tables: 1. Meetings, 2. Clients, the relationship between the two tables is one to many. So multiple meetings can be done wi...
• 1 me too
• Question
• In Progress
###### How to enter both CSS and HTML in a rich text field
I am trying to add CSS to a rich text field, but I cannot figure out exactly how to modify the CSS so that the field actually displays wh...
• 1 me too
• 2 replies
• Question