ContributionsMost RecentMost LikesSolutionsRe: Question about the round formula.Thank you so much Mark! This worked perfect. ------------------------------ Checho Najera ------------------------------ Question about the round formula. Hello guys :) I have a field with the number 4.2 and need it to round up to 4.5. The formula I am currently using is: Round([field],0.5) But it's giving me 4.0 as an answer. I'm sure it's a very simple solution, but I can't figure it out. Any tips/help? Thanks! ------------------------------ Checho Najera ------------------------------ Tecnnical Support re Conditional Dropdowns (or another way to solve this).Hey guys, it's my first posting my own discussion. I've used the community plenty of times to read up and solve problems on my end, so THANK YOU for being such a great community. So, pretty much what I want to do is filter the options I get on a proxy field based on a lookup field that comes from a priorly selected field. This is for an Inventory MGMT app. Let me explain each of the tables that will come into play here: 1. My first table is called Requests, where people send in their requests to our Warehousewhere they input certain info like their names and once they select their names, based on a lookup field, we get what area they work in. 2. The other table I got is called Materials, this is a list of all of the materials we track in our warehouse. This list is at about 350 materials (but not every area uses all of them). 3. And then my last table is a Many to Many relationship table that brings both of those together.When filling up a Request, the user gets an editable report where they select a Material and then input how much quantity they need. What I want to do is that, based on the Area of work of each specific name, they only get a list of Materials specific to that Area. Any idea on how to go about this? PS> I wanted to upload a video but wasn't able to, please send me an email so I can send it as attachment. There's also a link in case it works:ClickUp Clickup remove preview ClickUp View this on Clickup > https://share.clickup.com/clip/p/t1251230/b34fa86e-e7b7-498e-b0c8-8a3265fe53b6/screen-recording-2021-02-15-14%3A25.webm ------------------------------ Checho Najera ------------------------------