GeorgeHambel
Qrew Trainee
Joined 4 years ago
User Profile
User Widgets
Contributions
Re: Choose Users for projects
Happy to help! Duplicating relationships is not always a best practice and other options should be considered prior to doing so, but in your scenario you should be just fine. ------------------------------ George Hambel Project Manager Synctivate Inc ------------------------------18Views1like0CommentsRe: How to calculate the number of hours between date/time fields, excluding weekends
Hey Manohar, Easiest way to get this done would be to create a Formula - Duration field and input the formula below. [Date Two]-[Date One] Make sure under the "display" section you change the units dropdown to "Hours". (Will be defaulted to "Smart Units") Hope this helps! ------------------------------ George Hambel Project Manager Synctivate Inc ------------------------------159Views0likes2CommentsRe: Choose Users for projects
Hey Allison! You can accomplish this by duplicating your relationship from your parent table Employees to your child table Projects. After this you would do two things... Change the reference field of your 1st relationship to be titled "Related Sales Rep", and change the reference field of your 2nd relationship to be titled "Related Project Manager". For your drop down lists I would recommend creating a report on your parent table for each. In these reports, filter the first to only show employees in the "Sales Rep" role, and the second to only show employees in the "Project Manager" role. You can then base your record pickers on the reports you just created. Hope this helps you out! ------------------------------ George Hambel Project Manager Synctivate Inc ------------------------------16Views1like2CommentsRe: Formula Text
If those two criteria are the only that matter in this instance, the formula below will get it done. If([Application Status]<>"Approved" and [Closure Status]<>"Approved", "Done") If you have other options this formula should display based on different values in Application and Closure status, this formula can definitely be expanded upon. ------------------------------ George Hambel Project Manager Synctivate ------------------------------1View1like0Comments