-
Alerts & Notifications
Hello all, I'm trying to build a sheet that notifies the right person when certain new records are entered (e.g. alert Person X when a new record is entered that has a certain column equal to ABC). In reading through some of the posts, I understand that "conditional alerts" aren't developed yet so I'm looking for other…
-
Time Specific Tasks
Hi I have a project where the time for each task is key during a few days of it. i.e. a task is due to start at 10.00 and continue to 13.00. I may have missed something, but is there a way of creating this rather than just date specific? Thanks Nick
-
Building Asset Manager Template
Hello Community Would anyone have developed a Building Asset Management Template from the one in Templates. Inparticular regarding ongoing maitenance and periodic safety inspections? If not, I would be pleased to share when I develope one. Thanks in anticipation
-
Automating RYG balls based on checkboxes
I'm trying to create a function to accomplsh the following: If coulumn 2 is checked, and column 3 is not checked, then the RYG ball in column 4 is green. If Column 2 is not checked, and column 3 is checked, then the RYG ball in column 4 is Red. When nothing in column 2 or 3 is checked, no RYG ball is displayed in column 4.…
-
SS Anonymous
Hi SS users, i have been a user of SS for just four weeks and i need to know if there is a self help group for addicts! my first waking thought is about our SSheets and who is collaborating with who and i get excited at the thought that we are getting efficient at work and that we are actuallyu joining up the dots at…
-
Feature Request: Kick users off of sheets (using command or timer)
OK, so I'm working to fix the sheet for my team in China while they are all at home sleeping soundly. Problem is that over half their team is still logged into SS and viewing the sheet I want to fix. If their autosave features are set incorrectly, or they make the simple human error of treating this thing like an offline…
-
Approving Changes Made to A Shared Sheet
Hi all, long-time listener, first-time caller. I have been tasked with discovering a way that a sheet owner can control updates being made to a shared sheet through some form of 'approval' feature or process. My scenario is this: there is a master sheet displaying all approved, company-wide projects, complete with columns…
-
drop down list data validation
Can i make a drop down list referance a range of cells on another sheet? (like in excel i can name a range of cells and use that named range in a data validation drop down list)
-
Splitting a task by multiple people and show the percentages of that task assigned to them?
Is it possible to split a task by multiple people and show the percentages of that task assigned to them?
-
Feature Request: Reminders with a custom days before/after or more day options
I am interested in setting up a reminder for rows where the 'Target Date' column is 30 days away. I'm only able to set reminders 14 days before a date, but it would be really helpful to send reminders at least a month out for more long-term projects.
