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

Help with a Simple Formula
I am trying to calculate a formula that I can use in a dashboard graph. I need to show the following: status of a task (i.e. completed, in progress, etc) That it is US only (management responsibility) The end date is within the year 2026 This is what has been generated for me, through SS AI - COUNTIFS({My Sheet Name here…
Cross Sheet CountIfs(Or Formula Support
am I close? not even with AI can I get it right. =COUNTIFS(OR({Milestones Status} = "Active", {Milestones Status} = "Pending"), {Milestones Market} = Item@row )
Automation to Move cells without individual logic
Hi Smartsheet Community, I’m looking for assistance with optimizing our workflow for our project intake process. Here’s our current setup: All project requests come in via a single intake form. They populate into our Prioritization Tracker Rows are triaged as Declined (move to Declined sheet), Backlog (move to Backlog…