1

I am trying to populate a "modified (Date) cell with today's date and time stamp (date only needed) only after populating a dropdown cell with data (non-blank). I've tried NOT(ISBLANK), but to no avail. The dropdown cell is used as a status cell indicating i.e., "complete", "needs follow-up", etc.

2

Good morning, I have date columns created for the 5 milestone dates that each task/row can be assigned. Is there anyway to get all Milestone dates (date columns) to display in the calendar view.  I have set up color codes to help determine which is which but now I can't figure out how to get them