ContributionsMost RecentMost LikesSolutionsRe: Need help with IF functionThank you, Mark. I couldn't find that setting so I just changed the formula to say if[Actual Supplement Volume]=0, and it is working! ------------------------------ Beth ------------------------------ Re: Need help with IF functionAdam, You helped me before...hoping you can do so again. I tried to use the same formula again in a different field. Right now I have a field populate off of an Expected Infile Volume calculation. I want this field to update so if the Actual Supplement Volume is not supplied it will fill in with Expected Volume calculation.... Below is what I put as the formula. I have something wrong because now the field remains zero and only changes if the Actual Supplement Volume is filled in. If (IsNull ([Actual Supplement Volume]),(([Expected Infile Volume]*0.1)*1.75/21),([Actual Supplement Volume]/21)) Thanks in advance :) ------------------------------ Beth ------------------------------ Re: Need help with IF functionIt worked! Thank you so much for the help, Adam! ------------------------------ Beth ------------------------------ Need help with IF functionI would like to create an IF function formula for a date field. Currently I have 'estimated deployment date' field that is always filled in, another field, the 'rollout end date' calculates off the 'estimated deployment date'. Now, I would like to have an 'actual deployment date' field and IF provided override the 'estimated deployment date' calculation in the rollout date. my current formula for the 'rollout end date' looks like this:[Expected Deployment Date]+Days(90) I have no idea how to write this formula, or if it is possible. Any help is much appreciated. Thank you! ------------------------------ Beth ------------------------------ Re: exclude checkbox information from a reportThank you!!!exclude checkbox information from a reportI am tracking lead information, I do not want delete any leads so I added a check box 'Lost Business' that can be check or unchecked as needed. Within one report I am building, I would like to exclude any information for a particular lead 'lost business' check box is marked. any suggestions? Thanks in advanceRe: QuickBase Report, Only want to see data that is within the last 30 daysThank you for responding! AT first I didn't see what you were talking about! i just found it, THANK YOU!!!!! as usual i was over-complicating everything._QuickBase Report, Only want to see data that is within the last 30 daysI am totally new to formulas and quickbase I am trying to create a report for my dashboard that will only show data if theReceived Dateis within the last 30 days. Below is what I have so far, I don't know what to add it make it the statement true, so the items appear. Can someone tell me what direction I add to make the formula work? IF([Received Date ]<=[Today]