+4Hello 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:
Best answer by Sho
Hello @Herege ,
The following numeric functions are available
FLOOR(value)
ROUND(value,0)
ROUNDUP(value,0)
ROUNDDOWN(value,0)
+4The 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)
+4Hello @Herege ,
The following numeric functions are available
FLOOR(value)
ROUND(value,0)
ROUNDUP(value,0)
ROUNDDOWN(value,0)
Thanks a lot Sho, that helped and fixed my problem 🙂
+5Hi, 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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.