Community

1

Hi,

 

Is there a way to send a personal to do list that is created as an amalgamation of one person's tasks in multiple smart sheets?

 

i.e. If John Doe needs to do X in Project A, Y in Project B and Z in Project C, is there a live to do list that lists this for him? Where if he checks it off it

5

Hey guys.

 

So, I'm curious if there's a way to do something. I want to detect certain changes in a cell, and modify another cell based on the date those changes occur.

 

The goal here is to automate the entry of dates of completion. I've thought about entering the following formula in a date cell: