# Andrea Mayer’s Profile

points
133
Company
Marriott International

Hi all -

Trying to create a formula that raises a flag any time a milestone is NOT marked complete AND the due date has past.  Below is what I have tried and I am receiving an "Unparseable" error.

=IF(Stage2<>"Complete" AND [Due Date]<= TODAY, 1)

I am not sure that I am combining the two

Hello -

Looking for help with a basic formula that will calculate how many projects end within a certain number of days.

I have used: =COUNTIF({End Date}, <=TODAY(30))

I am not receiving an error message, but the result is much higher than the number is should be.

Hi all -

I would like to calculate if something is due this week based on a target date in another cell.

I have tried this formula:  =IF((TODAY() - [Week Of]1) - 7 > 0, "no", "yes")

This formula pull in a 'yes' for anything that is due in the next 7 days, which is not quite what I'm looking for.

Hello community -

I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me.

Is there a way

Hello all -

Needing help with a formula to calculate how many requests are submitted via a webform for each month.

2 questions related to this:

1. Can a formula pull just the month from a System Generated cell: Created by (Date)?

2. Where are errors in this formula:

=COUNTIF({Date Submitted},

Hello -

Is it possible to create a formula that only looks for some of the colors in the R/Y/G/G drop down column.

My drop down order in the Stage column is Not Started, In Progress, Completed. In my Status column I have Red, Yellow, Green, Gray.

I am looking to create a formula that enters a

Hello,

I am looking for help with the formula below. I am referencing another sheet and trying to calculate the number of rows that fall within January in the 'Milestone Due Date' column. The dates in the 'Milestone Due Date' column displayed in the following format: mm/dd/yy.

=COUNTIFS({Project},

Hello -

Is there a way to sort order of the items that appear in the Favorites section?  I don't see the 'Pin to Top' option in Favorites and do not see a way to drag sheets to the top that I would like to appear first.

Hello,

Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date.

=IF([Status]1 = "Completed", TODAY())