Welcome!

populate a field based on if a due date is x days or less.

anybody by chance know what is the easiest way it possible to set up a formula that reads

a field to auto populate a date that is say 10 days before another date (due date)

Formulas

Cell linking

How about using the NETDAYS formula?

Like this will trigger a flag "=IF(NETDAYS(TODAY(), [Due Date]2) < 10, 1)"

Try something like this...

=[Due Date]@row - 10

I am trying to add the number of passengers per month per year
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
Changes with predecessors
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
Formatting Issues with Index-Collect Formula
Hi all, I'm having some issues with an index-collect formula. I have (3) existing sheets that list a unique project name (text field), as well as a producer assigned to work that project. The producer column in all (3) sheets is set as a contact field. In a separate sheet, I'm trying to auto-populate the producer…