ContributionsMost RecentMost LikesSolutionsDoes anyone know of a resource allocation/scheduler tool native to Quickbase?Or buildable within quickbase? I have Projects, Tasks (within Projects), and Resources (assigned to Tasks) and want to assign dates to these Tasks based on availability of my Resource. Is this possible or do I need an add-on? Any help, recommendations, advice would be appreciated! Thanks all!Re: case formula returning one valueThank you both! Works great! case formula returning one valueNewbie here! Probably a silly error on my part but... I am trying to create a formula in the field "Mileage Cost" that will look at a date in the field "Date", find what year "Date" contains, and then multiply by a different number based on that year, then return that product back into the field "Mileage Cost". Currently, every "date" selected is returning a value of "2016" in "Mileage Cost." Case(Year([Date]),2015,([Mileage]*0.575),Year([Date]),2016,([Mileage]*0.54),Year([Date]),2017,([Mileage]*0.535),Year([Date]),2018,([Mileage]*0.545),null) Any ideas would be appreciated!