-
Continuous Links between Sheets
I have a master (parent) sheet linked out to several child sheets, the master effectively pushes header information out to the child sheets. When a new row is added to the master, the child sheets fire off a notification to various teams requesting their input. This may not be the most efficient setup but it currently does…
-
Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
-
Sharing - keeping info confidential to relevant parties
Hello, My colleagues and I have a large database containing information regarding suppliers. I need to share the information that is relevant to each supplier, with that supplier. I can obviously run a report to pull the data out based on 'Supplier' column in our sheet, as there are a large number of suppliers on this…
-
How to select different image source (camera app) when adding photos
Hello- Is it possible to default to a different camera in Android app when selecting to take a photo. By default the smartsheet app uses Android camera. I would like to use Skitch so we can add notes, arrows, circles, etc. to the photo. We are using this for a production line checklist. THANK YOU!
-
Convert gannt chart into monthly revenue forecast
I'm new to Smartsheet and am trying to build a revenue forecast sheet that updates dynamically from an MS Project gannt chart of multiple contract timelines. I'd like to be able import the gannt chart and show the revenue over the gannt chart timeline, have the $ show on the gannt chart by month (or week), then have the…
-
Return Column Name using a Formula
I have several columns I use to track dates for different steps in a process. i.e. Ordered, Delivered, Installed. Is there a formula that will return the column name of the latest date across these columns. For instance, Ordered = 8/4, Delivered = 8/15, Install = n/a. In my "Status" column I'd like to return "Delivered"…
-
AUTOMATIC Weekly Reminders
I've created a Meeting Agenda sheet that will be used during our weekly meetings. I'd like everyone shared to that sheet to receive a weekly reminder. How can I set this up to automatically send out?
-
change task color in filter calendar view
I'm sure this is very simple as I did it for one of my filters but not for the life of me can't figure it out again. Looking to change the color of my tasks in calendar view when I apply a filter. thanks Mike
-
Missing email collaboration
I keep stumbling over my desire to collaborate with team members via email or discussions. Discussions work OK, but I'd call them "Notes", unless I'm missing something (and I hope I am!). For example, if I want to include someone in a discussion many of the other tools I use let me type "@Ste" and it will popup all users…
-
Notifications - Direct Link to Changes in Specific Columns
Hi SS Community - We're looking to make discussions in Smartsheet easier for our users. Currently we have the notification set to address changes and additions to the comments column. The custom email is nice, but it's not exactly user friendly. Is there a way to hyperlink to an area of a smartsheet where a change was…
