-
Notifications and alerts - by demand (immediate)
Hi all, Was wondering if there is a way to send notifications (alerts & reminders) to the entire sheet (all rows at once) whenever a user needs and not by a pre-defined rule? For example, the sheet owner want to be able to send update requests or notifications in the middle of the week, not in a specific day that he/she…
-
Smartsheet Automated Tasks
Can you create an update request to have Smartsheet read incoming data being added to a new row for duplicate information? We are considering creating a web form for people to "register" with us and want to prompt them (or our staff) if they try and register twice.
-
Feature Request: Changing Rows in Scheduled Update Requests
It seems as if there's no way to change the rows to be updated in a recurring update request, currently. I think that this is very inconvenient and undermines the power of recurring requests: * I don't want to bother project managers with requesting status updates on already completed rows * I don't want to bother them…
-
View formulas globally in a sheet
Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this very helpful to: - Discover which columns I want to shade grey to indicate that they…
-
Automatic Update Request Based on Last Updated
I am looking to send out an automatic update request based on a system generated LAST UPDATED column if last updated was 10 days ago. The problem is, this function doesn't appear to be available in the alerts and actions and if i set up a reminder column, when the reminder triggers a check box or date, it updates the…
-
Check Box and Conditional Formatting
Hello, was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the expression has been meet and something is ready to send .. i was looking into if formulas…
-
Request for New Feature - Zoom - to speed navigation
I’m simply looking to navigate around the projects I currently have, as quickly as possible, to focus on the issues I would like to address with my staff. The challenge with the reports feature is it completely removes the indenting/nesting of rows, which as a result only causes more confusion. I would like to ask if…
-
All-in-one-place form for collaborators via Update Request?
In using Update Requests, is it possible (or HOW) to include the discussion thread, comments or a link to all that? And how can I include the connected documents, or a link to them? CONTEXT of question: When assigning tasks to collaborators with no spartsheet experience, I want to give them the chance to update the status…
-
Satisfy all requirements; with different formats of columns
Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox complete .. initially i think i need to use a countifs formula to tally all columns…
-
Adding to dropdown list
I have a dropdown list created, and I have it set to not restrict to the dropdown list only. I would like to know how to easily add values to the dropdown list without having to go into the column properties. Logically I would think if I type in a value in the cell it will add to the dropdown list, but it doesn't work that…
