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

Is there any automation workflow which saves the sheet after the trigger
I have a sheet where it have some formulas which works on present date. Because of using today function in the formulas, the formulas are not getting updated until I open the sheet and click save.
Trying to calculate total savings (Budget – Actual) when Column B contains both numbers and text
I have a Smartsheet with two columns: Column A Budget (numeric) Column B Actual Spend (mixed: numeric values, Blanks, or the text “NA”) I need a single formula that: Subtracts Actual Spend from Budget Includes only the rows where Actual Spend is numeric Ignores any rows where Actual Spend is blank or contains “NA”…
Average duration formula
I'm trying to get a formula for a sheet summary value to calculate average duration of rows where Risk Type = "EDAM Risk" and Status = "Resolved - Mitigated" or "Resolved - Decision." Assuming: Duration is in a column named Duration Risk Type is in a column named Type Status is in a column named Status I've been using the…