The Findmin formula searches among the entries of the linked column for the minimum value and returns it. This is useful if there are several entries in the linked table that refer to the same record (e.g. of a person or category) in another table.

You can use the Findmin formula with all alphanumeric values to determine the minimum value. Let’s say you use SeaTable for budget planning, where one table stores the expenses and another table stores the categories. You can then link each expense to a category. To find out what the lowest expense per category was, you can use the Findmin formula to display the smallest value from all linked expenses.

findmin formula

See the article about the link column for information on how to create a column of the type Link to other records. This is a basic requirement to be able to use the Findmin formula.

findmin formula

  1. Create a new column of the type Link formula.
  2. Set the Findmin option as the formula.
  3. Select the previously created column of the type Link to other records in this table.
  4. Now specify the column in the linked table to look up whose record with the minimum value should be displayed in the Findmin column.
  5. Select the column in the linked table to be evaluated in which you want to determine the minimum value.
  6. Click Submit.