Filters

Filters
contains
 
Problem
Description
Category
Solution
Solution in English
Formula Field Type
Discussion
Alternate Solution
Learn more
 
I need a formula that returns the reporting period month. Any date after the 18th of the month will return a reporting period of the following month   Dates If(Day([Date]) <= 18, Case((Month ([Date]))-1, 1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December"), Case(Month ([Date]), 1,"January",2,"February",3,"March",4,"April",5,"May",6,"June",7,"July",8,"August",9,"September",10,"October",11,"November",12,"December"))

If the day of the month entered into the [Date] Field is less than or equal to 18, then subtract one from the month of the date field and based on the month number return the matching name of month.

Else if the day of the month entered into the [date] field is greater than 18 then return the month of the [date field], and based on the month number return the matching month name.

Date     More on this solution...
Need to see the day of the week for a date. If only the day of the week is needed and not the whole date, then this formula can be used. Dates Case(DayOfWeek([YourDateFieldHere]), 0, "Sunday",
1, "Monday",
2, "Tuesday",
3, "Wednesday",
4, "Thursday",
5, "Friday",
6, "Saturday")
Note that the DayofWeek() takes a date, and not a workdate, so if the field is a workdate field, then you must convert it to date using ToDate(). Text     More on this solution...
Convert dates to European format Is there any way to change the default date format in my Date Identified field to the european DD/MM/YYYY? Dates Left(NotLeft(ToText([Date Identified]),"-"),"-")& "-" & 
Case(Left(ToText([Date Identified]),2),
"01","Jan","02","Feb","03","Mar","04","Apr","05",
"May","06","Jun","07","Jul","08","Aug","09","Sep",
"10","Oct","11","Nov","12","Dec")& "-" 
& Right(ToText([Date Identified]),"-")
  Text You can't do this within a date field. You must create a formula - text type field to display dates in this format.   More on this solution...
Color each row differently, based on the status of each task. You want to color code rows based on the value in the Status field. Row Colorization case([Status], "Not Started", "#FFCC99", 
"Started", "#99FFFF", 
"In Progress", "#FFFFCC", 
"On Hold", "#9999CC", 
"Completed", "#99FF99", "")
If the value in the Status field is "Not Started," then color the row a shade of orange (#FFCC99). 
If the value in the Status field is "Started," then color the row a shade of blue (#99FFFF).
If the value in the Status field is "In Progress," then color the row a shade of yellow (#FFFFCC).
If the value in the Status field is "On Hold," then color the row a shade of purple (#9999CC).
If the value in the Status field is "Completed," then color the row a shade of green (#99FF99)

If the value in the Status field is none of these, don't color it.
none - view builder formula This formula doesn't use the if() function. Because you want to set multiple conditions on one field, it's more efficient to use the case() function.   More on this solution...
Display a value that depends upon the value in a percent complete field Show status "not started" "in process" or "completed" based on the value in the percent complete field. Conditional (If - Then) Case(true,
[percent complete]=0,"not started",
[percent complete]<1,"in process",
[percent complete]=1,"complete","")
If the value in the percent complete field is zero, the display the text "not started." If the value in the percent complete field is less than 100%, then display the text "in process." If the value in the percent complete field is 100%, display the text "complete" Text A numeric percentage field shows values in percent format, like 50%, 75% and so on. But their real value is the exact mathematical representation of percent, which is always a portion of the whole number, one. For example, 20% is really.2 and 3% is really the number .03.   More on this solution...

We're glad you're interested in doing more with Quick Base!

Now we need to make you official before you share apps or manage your account.

Verifying your email lets you share Quick Base with others in your company.

Your work email
Your company
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
This report will be listed only for you, in the group Mine.
Only you can see the report in the panel. You can't ever list it for other users. You can still let others open it by sending them links.
Please wait while your new report is saved...
This is a new report
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:

Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quick Base often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quick Base finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quick Base needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table