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 you20Views0likes1CommentRe: 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])41Views0likes0CommentsAdd 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 BenjaminSolved150Views0likes4Comments