I want to give view permission to my user for limited time only. For this I have created a time column. Is it possible? If so how!
AND(
whatever expression you already have,
TIMENOW() >= [showTime],
TIMENOW() < [outTime]
)
Update: On a second thought, your times in the sheet should be UTC, and your expression should use UTCNOW() instead of TIMENOW(), otherwise, your users will be easily able to circumvent your restriction.
1 Like