Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I have a report that goes out daily showing which items are past due. The report is generated based a column that creates a flag when the line item is past due. On Monday the report went out but says that some one made the change to the cell according to the cell history. The report also looks the receivers that it came from this other user. I have checked with the other user and she has not made any changes. I have seen this happen a few times before. Any thoughts on what is happening?
I would have to ask the following question:
Does the flag get triggered when someone opens up a sheet on the day the items is past due? The changing of the flag may indicate that specific user because they are the one who opened the sheet and therefore triggered the formula that changed the flag.
You may want to test that scenario.
