-
Tracking the number of project work dates of multiple projects on one calendar
Hi, I am a new user of Smartsheet. I work for a Conservation Corps, where our contracts indicate total number of work days, and the actual work dates vary and move around based on our daily staffing and the sponsor's needs. It only matters that our projects are completed by the end of the fiscal year. I need to track total…
-
Display numerical date on Gantt Calendar
On the Project task list it will display the numerical date for the start of the week, and then Sun-Sat as single digit letters. Is there anyway to get it to display the numerical date for each day of the week?
-
CC Box for Emailing Rows
Not a question but a tip, enjoyed the webinar yesterday! I would like to see a CC box included when you send a row to an email. My boss asked me why I sent this request to update to him, and I sad, well its not directly to you there's no CC box! Thanks guys, Cameron
-
Discussion feature vs. Comments Column
Many templates have a Comments column. Why use a Comments column vs. the built in Discucsion feature? Somewhat related, is there a way of making the last bit of dicussions viewable llike in a column vs. having to click on the little icon? THanks, Rob.
-
Percent Complete - formulas
I have tried to make my % Complete column a formula which apparently is not allowed. I have 3 columns consisting of 1) Total story points; 2) Remaining story points and 3) % Complete. I want to use the following formula in the % Complete column ((Total Story Points - Remaing Story Points) / Total Story Points). Has anyone…
-
reassign to colaborator or anyone else?
When I reassign a taks to a colaborator, is it possible that the colaborator (or anyone else) receives a message (email) so that he/she is aware of the task?
-
Is there a way to validate that a particular cell cannot be left blank or allow junk entries?
In our application, we have the smartsheet as the user interface to enter the data and then this data gets transported into the database by an API according to a set cadence. For data integrity purposes, I want to ensure that certain key fields should not be left blank or allowed junk values.
-
Linking to data on SQL server
Does anyone know how I can link to data on an SQL server so that I can create a dynamic sales pipeline with data drawn from estimates actually created?
-
Using or not using hierarchies
For sales I have been advised not to use heirarchies to group things by areas like likelihood, potential size, stage of progress, etc, because once they're a few pages long it's a bit unweildy. I was advised to use no hierarchies for a sales pipeline and instead rely on Reports for all of that. But I see that with the…
-
2 days task do not create 2 days calendar events in google cal
I have a task in SS on a Gantt chart sheet, Start date 21/08/2015 and 2d duration. When I export this sheet to a google Cal the corresponding event in a 1 day event with the following Description: NOTE: This event was published from the Smartsheet named "HL Callendar". Changes you make in Google Calendar will not be…