-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Trying to create a fancy email with status reports from multiple teams
I'm trying to go a bit above and beyond, using SmartSheets to track the status of multiple projects across multiple teams. Currently, we have links to multiple sheets (one for each team) and they manually go in, add a new column per week, and fill it in with a bunch of text explaining the status of that project this week.…
-
Can I assign a task in Smartsheet to two people?
Hello community, My company is on a 21 day team challenge of utilizing Smartsheet to our best ability. I am working in a project plan for a client and want to assign a task to two people instead of the usual one person. That way both people can receive notification that a task is due. Is this a possibility? Thanks, Brian
-
Trouble Following posts
Hello, I am trying to stay active in the community but it is not emailing me when there are new comments. I have checked my settings to verify that my email is correct and I have checked the right boxes in the commmunity section. Is there anything else I need to do? Pic below. Thanks, Brett
-
Recurring Reminders
Is there any way to set recurring monthly reminders for each row for content which doesn't get updated? I am doing up a rental collection sheet, and need to set reminder for the person in charge on a monthly basis. Thank you.
-
Update start date with report
Hi all a quick question from a relative newbie: I am setting up a project sheet and want to be able to issue report updates to our outside contractors on a project. I am struggling with a feature in smartsheet. I would like to have my engineering firm provide a start date on a task with a dependency without having to…
-
Alert User in Row if Date has Past Due and not Complete
I would like to send an alert to the person "assinged" to the appropriate row the day after a "Due Date" IF a "Status" column has/doesn't have a value(s). For example, "Send 'Assigned To' and email reminder 1 day after 'Due Date' IF 'Status' does not equal 'Completed; Canceled.'" I want to target these communications to…
-
How to send a notification to a selected recipient
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notify [selected supervisor] of this change.
-
Alert when a row has not been updated in the last 14 days
A project lead has requested an alert that sends to him when a row (assigned to a project manager) has not been updated in the last 14 days. My attemtps at a solution: 1: Include the system column (Modified - Date) 2: Trying to apply conditional formatting to make it easily visible when viewing 3: Can't seem to work out…
-
Send Row Feature - Remove Log In button?
I'd like to be able to send rows to people that are not users in our SmartSheet account, but fill out a form that populates rows in our sheet. Is there a way to remove the Log In button in the header of the "Quick Update" email that goes out when you "send row"? I like the logo that is left justified in the header, but…