I need to formula to show if my application is more than 90 days old

Options
Corin
Corin ✭✭✭
edited 12/19/21 in Formulas and Functions

Example - I have a Today column, but need to know if Application fee invoice received date is more than 90 days from the Application start date , even if there is no application fee invoice received date. How do I show that in a formula?

Answers

  • Jeff M.
    Jeff M. ✭✭✭
    Options

    I can try to help you out but just to clarify..

    Would you like to be alerted at 90 days?

    Would a want a condition that highlights the cell yellow after 90 days?

    Would you want another column that would show a symbol after 90 days, like a flag?

  • Corin
    Corin ✭✭✭
    Options

    Hi Jeff- I'd love it if there was a condition for 90 days that was red if 90 days

  • Jeff M.
    Jeff M. ✭✭✭
    Options

    You could make 2 conditions using the application start date column and making two conditions like the example below. Just make sure you put them in order by priority otherwise the top will override the other. You can also select multiple cells that will change to red.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!