RYGB formula with Multiple criteria
IF phase is Pending and 15 days past date then yellow, 30 days past date then red, if phase is received then green. How do I write this?
Best Answer
-
Hi @K8te
Try something like this:
=IF(Phase@row = "Received", "Green", IF(TODAY() - Date@row < 15, "", IF(TODAY() - Date@row < 30, "Yellow", "Red")))
You didn't note what you want to see if the Phase is not "Received" yet the date is less than 15 days past the date. In this instance I wrote a blank cell, but you can replace whatever colour you'd like in between the two "".
See: IF Function / TODAY Function / Use Formulas to Perform Calculations With Dates / Create a Cell or Column Reference in a Formula
If this hasn't helped, it would be useful to see a screen capture of your sheet with the column names, but please block out any sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hi @K8te
Try something like this:
=IF(Phase@row = "Received", "Green", IF(TODAY() - Date@row < 15, "", IF(TODAY() - Date@row < 30, "Yellow", "Red")))
You didn't note what you want to see if the Phase is not "Received" yet the date is less than 15 days past the date. In this instance I wrote a blank cell, but you can replace whatever colour you'd like in between the two "".
See: IF Function / TODAY Function / Use Formulas to Perform Calculations With Dates / Create a Cell or Column Reference in a Formula
If this hasn't helped, it would be useful to see a screen capture of your sheet with the column names, but please block out any sensitive data.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thank you for your help. This works for me.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives