Returning n integer

[Herege]

Hello guys,

I'm struggling to achieve the desired results here.

First: I have a formula that return a number between 1-156 based on the created time of a record:

(VALUE(DATETIME_FORMAT(CREATED_TIME(), '0.smh'))*(156-1))+0000

Although I want this formula to return an integer and not with decimal values.

What to I need to change here?

Thanks in advanced.

[Herege]

The formula looks like is returning an integer but when I try to use to value on an automation it shows decimal value and so it doesn't match with the comparison I'm trying to make.

I wanna find a way to compare a number from a column from Table1 to a column on Table2.

If the value match I wanna use Lookups to pull fields from Table2 to Table1

Hope it makes sense.

Much Thanks

[Sho · Accepted solution]

Hello @Herege ,

The following numeric functions are available

FLOOR(value)
ROUND(value,0)
ROUNDUP(value,0)
ROUNDDOWN(value,0)

Formula Field Reference - Overview | Airtable Support

[Herege]

Thanks a lot Sho, that helped and fixed my problem 🙂