-
Can we set up our smartsheet to send email alerts to the team when a task has been completed?
We are a remote team and would like to set up alerts to notify the team wen tasks have been completed, is there any way of setting this up in smartsheet please?
-
Could anyone help me to apply the average formula to a couple cells, which at the same time had an "
Technical Part: I had in cell "[Q1 - Points]2" =IF([1.- Question]2 = "c) Right Answer", "10", "0") and in cell "" I had [Q2 - Points]2=IF([2.- Question]3 = "e) Right Answer", "9", "2") and both formulas work right by themselves. Nonetheless, as I wrote down =AVG([Q1 - Points]2:[Q2 - Points]2) in a new cell, the result was…
-
Advanced Cell Linking Capabilities?
When we list our monthly marketing promotions (what's new, what's on sale, what's exclusive) in our Marketing Master Plan, we link those cells to other sheets where it would be useful to have that data on hand (for copywriting, graphics design, email plan, etc). Only problem is that if something gets added at last minute…
-
Parent Rows as Milestones???
Is it possible to make a parent row a milestone as well?
-
Formatting
I have someone sharing their smartsheet with me but it is not translating their formatting to my view, what can I do? Thanks.
-
Suggested Visual Enhancements
On the Home tab View you currently display the left panel the number of Sheets there are in each of the Categories (Sheets, Folders and Workspaces). In the Centre Panel you display Name, Owner, Shared status and last updated, all very useful. I believe that there is room for two more columns which I suggest would be: ·…
-
Is it possible to apply conditional formatting to reports?
My current understanding of reports is that each row replicates the formatting from whatever sheet it pulls from. Is it possible to create conditional formatting rules within the report itself?
-
Automatic Staff Details
Hi All Is it possible to have detials auomatically filled in for a person. Eample i select person x from a drop down list to work on a course, the spreadhseet then gets the phone number and email adress of person x from a sperate spreadhseet and auto fills it. Thnaks in advacne for your help. Matt
-
Subtask Dependencies Error Message "REF"
I am getting a "REF" message in the subtask cell for Predecessor column. For example: Line 3 Start SF, start date: 8/18/15; end date: 8/18/15 = I entered the number 2 Line 4 Update SF, start date: 8/19/15; end date:9/17/15 = I entered the number 3 Line 5 Review SF, start date: 8/19/15; end date: 9/16/15 = I entered the…
-
Communicating "definitions or conventions" SmartSheet
All, I am new to SS. As I post a roadmap in SS I would like to communicate "definitions" in help text or somehow to the viewers of the SS. For example, I will have color flags to provide project status in terms of scope, schedule, cost, etc. How can I help the viewer understand my definitions for green, yellow, red?…
