TerriWells
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Nested IF Statement to Populate Field
Below is what the formula currently looks like: If([Proposal Received 2B Alight]<=[PWO Proposal Due Date],"Yes", Today()<[PWO Proposal Due Date]and IsNull([Proposal Received 2B Alight]),"Yes","No") I'm seeing two problems: When the "PWO Proposal Due Date" is originally filled in, the "Proposal Received 2B Alight" field will always be null So, when that field eventually gets completed, I need to determine if the CR was Late or On Time. The other issue I have is human error, if they enter a date incorrectly that field will never get updated. If I flip the formula, do you think that might fix the issue? Any suggestions would be helpful. Thanks, Terri Wells ------Original Message------ As Mark said you may need to flip the formula around because if the first line "[Proposal Received 2B Alight]<=[PWO Proposal Due Date]" is true it will always be Yes in the box even if the second condition changes. Which dates are changing and what are you expecting to happen when it changes?Re: Nested IF Statement to Populate Field
The formula above works great when the data is entered initially. The issue I'm having now, if the date fields change the "Yes" / "No" field keeps the original value. How do I get this field to update every time one of the dates change? As always, thanks for your help. ------------------------------ Terri Wells ------------------------------Report Using Multiple Tables
Hi Everyone, Is there a way to create a chart, that pulls in data from multiple table? I'm trying to create a Pie chart showing a count of On Time / Late proposals. This information is stored on four different tables. Any help would be appreciated. ------------------------------ Terri Wells ------------------------------Re: Calculate & Auto Fill a Date Field
I found the problem! I have two fields that the names are very similar, and I grabbed the wrong. Problem solved; thing work great when you grab the correct field. Thank you for your help and patience! ------------------------------ Terri Wells ------------------------------Re: Calculate & Auto Fill a Date Field
The field is on the form and I'm not getting any errors with the formula when I save the field. I've attached a document that shows the field configuration and formula, a copy of a report which I use for testing, and the two fields off the form where the "Proposal Approval to Alight" field is filled in but the "CR Proposal Due Date" is still blank. Hopefully, with this information you"ll be able is see my error. ------------------------------ Terri Wells ------------------------------Re: Calculate & Auto Fill a Date Field
I put the field on the form, but when I create the dynamic rule, under Action > Change the field is not there to be selected. So, I never got the point of checking the rule, because the isn't there to select. When I do a preview of the form I see the field, just not in the drop down, under Action > Change >select a field ------------------------------ Terri Wells ------------------------------Re: Calculate & Auto Fill a Date Field
I'm trying to create a report that lets the business community know if proposal are late from their vendor. The rule is that they have 15 days to return the proposal. I thought best way to handle this would be to crate a field, and do the calculations there. That way, if I need the information for anything else, it would be available. The business community doesn't want to see this information on the form, just in reports. ------------------------------ Terri Wells ------------------------------Re: Calculate & Auto Fill a Date Field
I'm sorry Mark, but I'm really confused. I'm a new-be, so please bare with me. Why would I check to see if my formula field, is not blank? If I've never entered data in the data entry field the formula field will always be blank. In the dynamic roll, after I select Action > Change, the field is not there to be selected. I did add the field to the form. How do I hide a field on a form? ------------------------------ Terri Wells ------------------------------
