KathyBenjamin
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Color a mulit-line text based on another field (mulitple choice) response.
Hello, I'm trying to find a way to color the text that is in a multi line text field based on another field (Multiple choice). If ([Mulitple Choice]="No",[Multi Line],color yellow) Any suggestions would be greatly appreciated. Thank you18Views0likes1CommentRe: Add 1 day to date formula
This formula worked. I am now being asked to add to the formula: RX Type = RX with Benefit Changes. I tried with this and it did not work. Any suggestions? If([REPORT: RX Type Description]="RX With Benefit Changes",and [REPORT: Rx Trigger Date] > [Report: RX Ready Date], [REPORT: Rx Trigger Date] + Days(1), [Report: RX Ready Date])30Views0likes0CommentsAdd 1 day to date formula
Hello, I need help with writing a formula to add a day to a date formula. If([RX Trigger]<[RX Ready Date] add 1 day to the RX Trigger date to be the new RX Ready date. Ex: RX Trigger 10/30/2024 and RX Date 10/29/2024. Result needs to be RX Ready Date 10/31/2024. Thank you Kathy BenjaminSolved103Views0likes4CommentsFormula help for Multi Select Text
Hi, I'm looking for help with a formula to display a field that is a Multi Select Test field and if blank display another Multi Select Text field. Example: If [LG Audit] is blank display [Out of Scope]. Is this possible? Thank you in advance.96Views0likes2Comments- 116Views0likes0Comments