ContributionsMost RecentMost LikesSolutionsRe: Help with date formula to display next appointment dateHi, You can use Workdays formula for calculating next appoint date. WeekDayAdd([Start Date],[Business Days]). Ex. If your taking appointment date for next week in working day Syntax Start date : 05-Sep-2018 business day : +5( it will calculate next 5 working date from calendar ) >> 12-Sep -2018 display as next five working date. Re: Date FormulaHi You can use WeekdayAdd( date , week days )Weekenddays option to finding duration or target date . Re: field with color condtionHi, I need to add another filed in this formula ex: "status" is a parent field and it consist of dropdown option ,and it is unable to process for formula in the same field .is there any option to add both dropdown and formula. status - filed field type : dropdown final view in field : if any drop down list is selected color of the field need to change automatically . customizing email alert from Notifications, subscriptions, & remindersNotifications, subscriptions, & reminders Below step for email alerts --->Table name --> Settings --> Click on New Email --> Select --> Reminder --> Customize as per your requirement. --> click ok field with color condtionCase([Status :], "COMPLETED", "<div style=\"color:black; background-color:#00FF00;\"> COMPLETED</div>", "IN-PROGRESS","<div style=\"background-color:#0000FF;\"> IN-PROGRESS</div>", "OVERDUE", "<div style=\"background-color:#FF0000;\"> OVERDUE</div>", "REJECTED", "<div style=\"background-color:#FFFF00;\"> REJECTED</div>", "QUERIED", "<div style=\"background-color:#FFFF00;\"> QUERIED</div>", "DELAYED","<div style=\"background-color:#FFA500;\"> DELAYED</div>", "") Re: Changing Font Size and/or Color on dashboard pagecan you provide basic formula to get font in color ? When due date occurred font style and color should need to change.