Help

Re: Returning n integer

Solved
Jump to Solution
1652 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Herege
5 - Automation Enthusiast
5 - Automation Enthusiast

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.
1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

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

See Solution in Thread

3 Replies 3
Herege
5 - Automation Enthusiast
5 - Automation Enthusiast

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
11 - Venus
11 - Venus

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
5 - Automation Enthusiast
5 - Automation Enthusiast

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