I am a fairly new SS user and am owner/admin for a large project/Gantt sheet that is shared internally with other Project Managers, who are also fairly new to SS. They have edit permission, but are not admins. I have set the project option to open the sheet/Gantt view to 'today's date'. My Gantt view opens as…
Hi, I want to set today's date in a date column when the status, in a status column on that row, is set to something other than 'open'. I don't want the date to change once it is set so the TODAY() function does not work for me. Is there a function to do that? Regards Mike