Lisa✭✭

I believe the issue was that Microsoft's junk mail filter technology was updated (they do this regularly). This explains why e-mails to Gmail weren't being deleted, also. I added Smartsheet's e-mail addresses as safe senders and that seems to have taken care of the problem. The automated e-mails come…

Yes, I think it is on the Outlook side. I am hoping someone else may have had this issue with Outlook and can offer advice.

I'd like to see the location in the sheet itself as Dave mentioned. Any way to do this?

Each sheet has a column, "/" is manually entered when in progress. The report is to show the status of several of these so the values are put on one line with a helper column for the report.

That's a good option. I was hoping the helper column could also help me identify when someone accidentally erases a formula which happens too often around here. I don't see any functions like ISFORMULA (Excel has this), though.

What do you put in the helper column to indicate a formula?

How many years is this going to continue unaddressed? And no one wishes to look into Dynamic Views...

Thank you very much! I will give this a try!

I thought I did on my first post, but here it is again just in case.

Solved my own issue, I guess coffee hadn't kicked in yet - =IF(COMP@row = "X", 0, TODAY() - [DUE DATE]@row)