I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific date.
I have a Report that uses the 'is greater than-date modified' but I get results from all over the place - totally inconsistent - so I'm not sure what Smart Sheets constitutes as 'modified'.
Alternately I try placing a system column directly in the sheet called 'Modified' - this updates every row with the current date every time the sheet is saved, which explains the previous statement.
Surely this is not the correct behaviour for 'modified' as it becomes completely useless if it considers every row to modified by simply opening and closing the file.
Can anyone shed some light on how to achieve what I am after?