Formula based on date and status columns

04/29/21
Answered - Pending Review

I currently have the below formula in a column titled "Health' to create a symbol if the request was created more than 21 days ago (red) or less than 21 days ago (green). However, I want this formula to also include the status column that would include "received" or "open" and exclude the "submitted" status. How do I do this?

Current formula without status column being included:

=IF([Request Creation Date]@row < TODAY(-21), "Red", "Green"

Answers

  • Mark CronkMark Cronk ✭✭✭✭✭

    Good evening,

    Try:

    =IF(AND([Request Creation Date]@row< TODAY(-21), [email protected] <> "submitted"), "Red", "Green")

    Work?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

  • Linda FunkLinda Funk ✭✭✭✭

    I inserted the below formula, (note: the accurate column title is "Submitted (SOW presented to requester, waiting response)" and the rows that have been submitted are still returning a red or green symbol.

    =IF(AND([Request Creation Date]@row < TODAY(-21), [email protected] <> "[Submitted (SOW presented to requester, waiting response)]"), "Red", "Green")

  • Mark CronkMark Cronk ✭✭✭✭✭

    Try:

    =IF(AND([Request Creation Date]@row < TODAY(-21), [Submitted (SOW presented to requester, waiting response)]@row <> "Submitted"), "Red", "Green")

    Work this time?

    Mark


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Sign In or Register to comment.