nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Set a flag 90 days before due date and after due date

JCope

I am trying to flag contracts needing renewals. What am I doing wrong?

=IF(OR([Contract end date]1 <= Today1 + 1 - 90, 1, 0))

Find more posts tagged with

Hospitality

Services

Account and User Management

Comments

Jeff Mullins

I use Smartsheet for property management and need the lease end dates to be flagged too. I simply use the "countif" formula such as =COUNTIF(CHILDREN(), <TODAY()) + " expired" to do the job of giving me a total of all expired. I then link that field to my dashboard for a global view. You could do the same for 90 days such as =COUNTIF(CHILDREN(), <TODAY(90)) + " expiring in 90 days" to do the same for 90 days prior. I also use the conditional formatting feature to turn each red or yellow based on expiring 90 days (and also 30 days) from today. Also, you can set an alert to email you when a date is at a certain time frame from today.

sean59916

Hi -

It looks like you don't have the OR condition built correctly for the 2nd expression- it would need to be something like:

=IF(OR([Contract End Date]1 <= TODAY() + 1 - 90, [Contract End Date]1 <= TODAY() + 90), 1, 0)

Alternatively, you could use =IF([Contract End Date]1 > TODAY() + 90, 0, 1)

This flags any past due item and anything within 90 days. See screenshot.

I hope this helps you out?

Sean

JCope

Thank you so much! The IF/OR logic is working perfectly.

Sign in to join the conversation!

Quick Links

Trending discussions

"Fields marked with an asterisk (*) are required." line on every form.
Hi, "Fields marked with an asterisk (*) are required." is the very first line in the body of every form I create. I don't remember seeing it before (unless you missed filling out a required field; then you would see the message). Is there a way to turn it off or change it? None of my forms are in English so the message is…
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
Dynamic View Issue - Group Sharing
I have a dynamic view setup for a dashboard that has NO restrictions And on the Sharing tab, I have a Group that I created as the additional share access to the view But the individuals in the Group still cannot see the data from the dashboard. Am I missing something? Because when I share the view to them individually…