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

Sum if match formula
Hello, I am looking for a fairly complicated formula (I think). I have two sheets: 1) IW POD and 2) Root Bushing Repair Tracker on sheet 2, I have a column named "Actual Execution Hours" In that column, on sheet 2, I need to sum the hours on sheet 1 in column "Total Actual Hours" IF these two columns match on both sheets -…
Formula working for one data value but not another
Hi Community, I have a sheet that contains, among others, columns titled "Priority" and "Contract ID". Multiple rows can have the same Contract ID and the same Priority. Priority values are 1-2-3 and restricted to dropdown list values only. To collect the number of unique Contract IDs that are Priority "1", I have this…
COUNTIFS formula across sheets
Hi all I've been using Sheet Summary's to calculate some data which seems to work quite well. For instance this is an example of a Summary that is working fine. (Its an ISO27001 audit tracker sheet) =COUNTIFS(Finding:Finding, "Opportunity for Improvement", Status:Status, <>"COMPLETE", [Agreed closure date]:[Agreed closure…