I have a formula (or script, really) in my spreadsheet that checks the time a file (accessible from the app) was last updated, and enters it in DateTime format. However, if there is no such file, it returns FALSE.
I would like to hide all the files that have FALSE in the [Last updated] column, and set up a formatting rule, to colour the row red, so I can easily see which documents Iโm missing.
However, I cant seem to make any evaluation, neither in formatting or in show-if-rules, on weather a values is a valid DateTime or notโฆ
Any help?
LinkedIn
Twitter
