# Formulas & functions

## Conversations

Recent Conversations
Conversations 121 - 135 of 3019
###### Date Validation in multi line text field on Save
I have a multi line text field where I record the course taken by an employee. I am maintaining the history of these dates. But since its...
• 1 me too
• 4 replies
• Question
###### How to deploy sandbox applications to production
I have posted an article on LinkedIn on this topic. Let me know your feedback.
• 1 me too
• 0 replies
• Question
###### Text List Cannot Be Used In A Formula?
So, the new "text list" field type cannot be used in a formula?
• 1 me too
• 2 replies
• Question
###### 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
###### 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
###### 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