# \#formula-fields

**URL:** https://forums.knack.com/tag/formula-fields/145.md

[Latest](https://forums.knack.com/latest.md) · [Categories](https://forums.knack.com/categories.md) · [Tags](https://forums.knack.com/tags.md)

---

## [Max/Min Dates in Formulas](https://forums.knack.com/t/max-min-dates-in-formulas/9513)

<div class="topic-metadata">

**Author:** [@JeremyNels15348](https://forums.knack.com/u/JeremyNels15348)\
**Replies:** 23\
**Last updated:** [March 2, 2023, 5:01pm UTC](https://forums.knack.com/t/max-min-dates-in-formulas/9513 "2023-03-02T17:01:07Z")

</div>

We need to be able to calculate the earliest/latest date from a set of connected records (e.g. first client visit or last client visit). Max/Min don't currently work for date fields.

---

## [Table Summaries by column](https://forums.knack.com/t/table-summaries-by-column/6194)

<div class="topic-metadata">

**Author:** [@JoshuaHorw47792](https://forums.knack.com/u/JoshuaHorw47792)\
**Replies:** 1\
**Last updated:** [November 21, 2017, 12:02pm UTC](https://forums.knack.com/t/table-summaries-by-column/6194 "2017-11-21T12:02:02Z")

</div>

I would like to control what kind of summary a table does column by column. For example some columns I'd like a sum and some I'd like an average. Right now the best I can do is have the whole table do a sum and average, …

---

## [Make formula results an option when setting a default value](https://forums.knack.com/t/make-formula-results-an-option-when-setting-a-default-value/6175)

<div class="topic-metadata">

**Author:** [@Charlie24782](https://forums.knack.com/u/Charlie24782)\
**Replies:** 1\
**Last updated:** [September 24, 2017, 6:45pm UTC](https://forums.knack.com/t/make-formula-results-an-option-when-setting-a-default-value/6175 "2017-09-24T18:45:37Z")

</div>

It would be nice to have the ability to create a calculated field or text formula in an object and have that field available as a default value for another field in the object.

---

## [Display the date of the first and last date in almost of connected records](https://forums.knack.com/t/display-the-date-of-the-first-and-last-date-in-almost-of-connected-records/6134)

<div class="topic-metadata">

**Author:** [@ArvedDeeck55041](https://forums.knack.com/u/ArvedDeeck55041)\
**Replies:** 1\
**Last updated:** [June 6, 2017, 5:11am UTC](https://forums.knack.com/t/display-the-date-of-the-first-and-last-date-in-almost-of-connected-records/6134 "2017-06-06T05:11:57Z")

</div>

Just as there is a Maximum and a Minimum field for connet d number records, there should be a "first" and "last" option to display the first or last date times in date time formats. There is a hack for that by going thro…

---

## [Table Row Summary - COUNT](https://forums.knack.com/t/table-row-summary-count/9748)

<div class="topic-metadata">

**Author:** [@RyanRuckel87002](https://forums.knack.com/u/RyanRuckel87002)\
**Replies:** 5\
**Last updated:** [March 23, 2016, 6:34pm UTC](https://forums.knack.com/t/table-row-summary-count/9748 "2016-03-23T18:34:33Z")

</div>

It would be helpful to include COUNT as an option for a table row summary. The count could update based upon the number of records actually displayed in the table.

---

## [Feature: "Most recent" option in calculated field](https://forums.knack.com/t/feature-most-recent-option-in-calculated-field/5703)

<div class="topic-metadata">

**Author:** [@SimonChapl76845](https://forums.knack.com/u/SimonChapl76845)\
**Replies:** 3\
**Last updated:** [October 19, 2015, 2:50pm UTC](https://forums.knack.com/t/feature-most-recent-option-in-calculated-field/5703 "2015-10-19T14:50:02Z")

</div>

It would be great to have a "most recent" option in the calculated field, as a different option from min, max and average. It would be particularly useful for date driven records.