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?
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.
Thank you for your help. This works for me.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.