# Can someone hep me with this formula please

**URL:** <https://connect.superhuman.com/t/can-someone-hep-me-with-this-formula-please/38627>\
**Category:** Product Feedback\
**Created:** [March 22, 2023, 11:00am UTC](https://connect.superhuman.com/t/can-someone-hep-me-with-this-formula-please/38627 "2023-03-22T11:00:37Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Karlie\_Shelley](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/karlie_shelley/32/33891_2.png) [@Karlie\_Shelley](https://connect.superhuman.com/u/Karlie_Shelley)\
**Post date:** [March 22, 2023, 11:00am UTC](https://connect.superhuman.com/t/can-someone-hep-me-with-this-formula-please/38627/1 "2023-03-22T11:00:37Z")

</div>

Hello ! My brain isn’t wired to work out formula’s and any help would be super appreciated!

Someone created a formula in my doc and i can’t reach them to ask for their help. I need to work out what information I need to be writing to make the formula work. In the photo attached there is something written before the quote in the ‘Full Quote’ column that then disappears and adds the information to the ‘Time/Quote Start’ column. I have also attached an image of the formula. Thanks so much and I hope that i am making some sense !

 ![Screenshot 2023-03-22 at 10.56.11](https://global.discourse-cdn.com/coda1/original/3X/7/7/779392c990281a1905b3d709fa81ef433b07ad6b.png)

---

<div class="post-metadata">

**Author:** ![Mario](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/mario/32/12232_2.png) [@Mario](https://connect.superhuman.com/u/Mario)\
**Post date:** [March 24, 2023, 4:01pm UTC](https://connect.superhuman.com/t/can-someone-hep-me-with-this-formula-please/38627/2 "2023-03-24T16:01:50Z")

</div>

Hi @Karlie_Shelley 🙂

It would help a lot if you could share the doc, maybe someone will have the time to give it a look 🙂

In the meantime, that formula just say

Take the timestamp, make it into a text, add an “@”, add the full quote text, and cut it at the 20th character, and something else that is not seen there

This looks like a really custom function, that is probably related to whatever the doc does ahahah

Best suggestion is to ask to whoever made that doc in that way 🙂

---

<div class="post-metadata">

**Author:** ![Pch](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/pch/32/17688_2.png) [@Pch](https://connect.superhuman.com/u/Pch)\
**Post date:** [March 26, 2023, 5:57pm UTC](https://connect.superhuman.com/t/can-someone-hep-me-with-this-formula-please/38627/3 "2023-03-26T17:57:30Z")

</div>

Welcome to the Community @Karlie_Shelley 🥳 !

I don’t known exactly what the problem is with your formula (except for the fact that someone somewhere used `+` to concatenate things) but you could try this maybe, using [Concatenate()](https://coda.io/formulas#Concatenate) :

```auto
Concatenate(
  thisRow.Timestamp.ToText(),
  "@'",
  thisRow.[Full quote].Left(20),
  "…'"
 )

```

Or this with [Format()](https://coda.io/formulas#Format) :

```auto
Format(
  "{1}@'{2}...'",
  thisRow.Timestamp.ToText(),
  thisRow.[Full quote].Left(20)
)

```