- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 10, 2023 08:13 PM
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:
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 10, 2023 08:48 PM
Hello @Herege ,
The following numeric functions are available
FLOOR(value)
ROUND(value,0)
ROUNDUP(value,0)
ROUNDDOWN(value,0)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 10, 2023 08:27 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 10, 2023 08:48 PM
Hello @Herege ,
The following numeric functions are available
FLOOR(value)
ROUND(value,0)
ROUNDUP(value,0)
ROUNDDOWN(value,0)
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 10, 2023 09:46 PM
Thanks a lot Sho, that helped and fixed my problem 🙂
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 30, 2025 12:30 PM
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!
