Paul Newcome’s Profile

Community member since April 2018



Good morning, we have a sheet we are using to track leads. I've been asked to set up an automated update request to send leads that have a certain status out on the first business day of each month. 

In the automated actions, there is no way to set a recurring update request like there is on the


Is there a way to use the MONTH function with COLLECT to, say, find the highest date in a column that is in the month of October? Basically, to simplify a formula like this:

=MAX(COLLECT([Due Date]:[Due Date], [Due Date]:[Due Date], >=DATE(2018, 10, 1), [Due Date]:[Due Date], <=DATE(2018, 10, 31)))



I have a tricky formula I'm trying to calculate, but with no success so far... 


I have to different sheets that I'm looking on. 

Sheet1: Planning and monitoring sheet

Sheet2: Work reports

The formula challenge:

In Sheet2 our guys at the field are reporting on different predetermined projects.


I am looking for a formula that when I checkmark a box (to show a task completed) the column next to the checkmark will auto populate the date the box was checkmarked. I also want it to stay that date unless that row or checkbox is modified/unchecked.  

I got as far as the date populating but the