# Creating formula **URL:** \ **Category:** Formulas\ **Tags:** tutorial\ **Created:** [July 25, 2023, 12:30pm UTC](https://forum.seatable.com/t/creating-formula/2601 "2023-07-25T12:30:17Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Kingsley](https://forum.seatable.com/user_avatar/forum.seatable.com/kingsley/32/3119_2.png) [@Kingsley](https://forum.seatable.com/u/Kingsley)\ **Post date:** [July 25, 2023, 12:30pm UTC](https://forum.seatable.com/t/creating-formula/2601/1 "2023-07-25T12:30:17Z")
Hello. I have 2 tables in Seatable spreadsheet. One is Contacts and the other is Interactions. A column in Interactions table is a pull up( linked) of Names column in Contacts table. Each time I have an Interaction with someone in the Contacts table I go to the , Interactions table and log the Interactions, linking that Interactions to that person. So I want a scenario whereby each time I log an Interactions in Interactions table, A column called Last Contacted in the Contacts table is automatically filled with last date of the Interactions with that person. Can you help me do that? Maybe with formula ---
**Author:** ![AkDk7](https://forum.seatable.com/user_avatar/forum.seatable.com/akdk7/32/2186_2.png) [@AkDk7](https://forum.seatable.com/u/AkDk7)\ **Post date:** [July 25, 2023, 1:10pm UTC](https://forum.seatable.com/t/creating-formula/2601/2 "2023-07-25T13:10:20Z")
Hi @Kingsley. You can use the column type “link formula” for it. The “findmax” formula will show you the latest value of all linked records from the interactions table. ![Bildschirmfoto 2023-07-25 um 15.07.45](https://forum.seatable.io/uploads/default/original/2X/6/67490ddceb7f36a943190aa0c6244e6643276f3d.png) ---
**Author:** ![Kingsley](https://forum.seatable.com/user_avatar/forum.seatable.com/kingsley/32/3119_2.png) [@Kingsley](https://forum.seatable.com/u/Kingsley)\ **Post date:** [July 26, 2023, 11:04am UTC](https://forum.seatable.com/t/creating-formula/2601/3 "2023-07-26T11:04:42Z")
Okay. Thanks it did work. I noticed that freezing of first column in Mobile version isn’t possibe. Is that the app behavior? Also, if possible, a column type for phone could be made available. So that one can directly call,send sms or Whatsapp directly to a contact from seatable. Email column type is available. So I think that phone column type could also be made available. I noticed that formatting option in Long Text column type isn’t available in mobile. It is only web version that allows formatting of text. Is there automation in the seatable? ---
**Author:** ![rdb](https://forum.seatable.com/user_avatar/forum.seatable.com/rdb/32/1869_2.png) [@rdb](https://forum.seatable.com/u/rdb)\ **Post date:** [July 26, 2023, 7:26pm UTC](https://forum.seatable.com/t/creating-formula/2601/4 "2023-07-26T19:26:02Z")
Please open a new topic for new questions. You can post feature requests at [https://ideas.seatable.io](https://ideas.seatable.io) Additionally, please consult the SeaTable Docs at [Help - SeaTable](https://seatable.io/en/docs/). You’ll find plenty info about automations. ---
**Author:** ![Kingsley](https://forum.seatable.com/user_avatar/forum.seatable.com/kingsley/32/3119_2.png) [@Kingsley](https://forum.seatable.com/u/Kingsley)\ **Post date:** [July 26, 2023, 7:59pm UTC](https://forum.seatable.com/t/creating-formula/2601/5 "2023-07-26T19:59:44Z")
Couldn’t find the seatable docs for automation tips ---
**Author:** ![fsa](https://forum.seatable.com/user_avatar/forum.seatable.com/fsa/32/2567_2.png) [@fsa](https://forum.seatable.com/u/fsa)\ **Post date:** [July 27, 2023, 6:21am UTC](https://forum.seatable.com/t/creating-formula/2601/6 "2023-07-27T06:21:35Z")
[Here](https://seatable.io/en/docs/automationen/uebersicht-ueber-automationen/) you can find an overview about automations in SeaTable. Please note, automations are only available from the Enterprise version. ---
**Author:** ![system](https://forum.seatable.com/uploads/default/original/1X/04603423fe81a46c321283663086c475429e8ccb.png) [@system](https://forum.seatable.com/u/system)\ **Post date:** [July 29, 2023, 6:22am UTC](https://forum.seatable.com/t/creating-formula/2601/7 "2023-07-29T06:22:04Z")
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.