-
networkday trigger for update request -- requires opening sheet?
I have a number of update requests that I've set up to "trigger" from a column that calculates the number of networkdays left before a due date. For example, I want a manager to update the page count of a report 3 days before that report goes out to an editor so that we know if the length has increased. But, if that…
-
Row sharing work around suggestions?
I am a new user of smart sheet. I have recently just set-up smartsheet as a tool to track around 200 customer work requests that are going through a University manufacturing workshop. The nature of the work means that there needs to be a reasonable amount of exchange of information between the technicians doing the…
-
Contacts and Contact Groups
Can you share contacts or contact groups with other smartsheet users? Similar to how you share a filter or another way?
-
Automated Approval Requests
HI , I Have set up an Approval Request Which works amazing My only Issue is that my client that needs to approve the job Request Gets in his email for each Request line an email but its an auto Reply to the Previous Request Is there a way by the delivery settings to set that the subject of the email should always Reference…
-
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…
