Need help with IF function
I 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 '...
Forum Discussion
Try this Beth:
------------------------------
Adam Keever
------------------------------
If( IsNull([actual deployment date]), [Expected Deployment Date]+Days(90), [actual deployment date])
------------------------------
Adam Keever
------------------------------
Adam,
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
------------------------------
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
------------------------------
- MarkShnier__You
Qrew Legend
It sounds like the IsNull ([Actual Supplement Volume]), is not working. Look for a setting
Treat blank values as "0" in calculations
and uncheck that. That will cause the formuals which refer to this field to differentiate between a zero and a (blank).
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------- Thank 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
------------------------------
