Skip to main content

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.

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

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

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


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

Hi, I have this problem too. This is the formula:

ROUND(AVERAGE(a,b,c),1)

where in the table a=4   b=5   c=5
The formula preview correctly shows 4.7.
The problem is in the cell that shows 5.

Look at the screenshot, please help me!

Reply


Terms & Conditions