AngelaBowman
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Number of days
I have two fields- estimated completion date and date completed. I am trying to create a formula to populate the number of days to complete the project ONLY if date completed is null. I can create the formula and make it work if I leave out the completed part, put am getting an error when trying to incorporate the completed field. ------------------------------ Angela Bowman ------------------------------7Views0likes3CommentsWeekly emailed report when a field is added or modified
I have a table that contains 1000s of contacts. I am trying to create a weekly notification that is emailed to a user when a specific field (email address) is added or changed. I can create a notification for each record, but would rather it only be emailed weekly for those that have been added or changed. Any help is appreciated. Thank you. ------------------------------ Angela Angela ------------------------------Add Multiple Records to New Table
We have a list of contacts and every few years we need to review them for changes. There is a review table that we created that asks the reviewer a number of questions. In the original table, when the contact is set to be reviewed, there is a "Add Record" button that will add the contact to the review table. The issue is that our database has grown significantly and I now have over 200 "Add Record buttons. Is there a way to get all of the reviews initiated at once?17Views1like3CommentsRe: Formula - Date if a condition is true
Works Great. Thank you. I'm trying to flowing the same logic for another field, but thinking I have too many variables... I need a field to return one of two due dates if a specific field is not picked... The three fields are: Short or Long? - Multiple Choice Due date- date field Extension due date- Date field only if a box is checked. If Short is chosen, then return "NA". If long is chosen, then I need it to return a date 30 days after either the due date or extension due date if box is checked. Any Thoughts?73Views0likes0Comments