Formula Help - Greater than X days in <Date Column>

1

Purpose: - I’d like to create an easy system for the team to see when a project hasn’t been updated in 6 days so the team can hold itself accountable.

Specific Idea - highlight the text update field if it’s more than 6 days since an update.

Request - I am new to the formula language and don’t understand what formula to enter into the conditional formatting formula editor.

I’m trying to add a formula to conditional formatting that would highlight every row that has a modified date of greater than 6 days

2

HI James,

Try this:

image
image944×326 28.6 KB

Regards
Rambling Pete

1 Like
3

Thanks for responding Pete. I’m trying to do this based on a change to a particular column in the row. So I changed thisRow for the Column Name, but it seems to be applying the column to every row now.

I added Last Updated, which shows the modified date of This Week’s Update for context.

Screen Shot 2022-09-07 at 3.27.07 PM
Screen Shot 2022-09-07 at 3.27.07 PM1028×704 111 KB

4

Hi James:

Coda only keeps track of the last change to the row, not of any particular column. But since you have the date in the Last updated column, you can just say “Last Updated” - Today() >6.

Just for interest: below is how I capture updates in my doc -

  • There is an update column
  • An archive column of previous updates
  • And a button to move the most recent update to archive, to make room for the new entry. But with a button we can do anything. Currently I put today’s date as a prefix to the new update, you could also put the date in your Last Updated column"

image

P

5

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.