-
Smart Sheet for tracking customer onboarding process for Saas company
Hello Smartsheet community members, I am on trial and trying to learn ways to setup smartsheet in order to track customer onboarding process. My company is creating and selling software to customers (Saas) and we are looking for ways to improve our internal communication to help our customer adaping our software quicker…
-
Same Varibale Function and having all rows with an entry that have a entry that match being formated
I wondering if there is a way to have conditional formating based on if the variable in a column that is the same as another. For example. I want one column to have a decision option. Yes, No. If its yes, and the Applicant column has the same name in it, all rows with that name will turn to yes in the Decision Colomn Hope…
-
External References
Hello, I would like to create two separate sheets where in the second sheet I can make reference to cells in the first sheet. Is this possible and if so, will the data update automatically in sheet 2 when sheet 1 is altered. Thanks. Sherry
-
How do I outdent a row so that I can delete it? Because it does not allow me to delete a row once I
How do I outdent a row so that I can delete it? Because it does not allow me to delete a row once I have indented it?
-
Formula to calculate count of checkboxes in multiple columns and child rows
Hi Everyone, I'm trying to write a formula that adds up the number of unchecked child rows in the Complete column and then subtracts the number of checked rows from the Non Applicable column. The result should be a number of tasks left to be completed from within that parent and child section. I've tried a bunch of…
-
Need help setting up a simple report
Trying to figure out how to set up a report that would simply list my projects and percentage of completion of each project. i do not need to see primary tasks, just one line per project with the smart sheet name, date started and due, and percentage of completion. I have tried to set it up cannot find a way around Primary…
-
Calendar view - change colours of bards
Hi there, I have just started using smart sheets. I have various elements in my project and want to colour code them so that you can see on the calendar view the different elements instead of the stage. thanks Mel
-
Determine Hours from Duration
Has anyone created a sheet or formulas to calculate the montly hours from duration? This is easy if the entire duration falls in one month but I'm struggling with calculating the monthly hours for extended durations. For example, how many hours are allocated in each month if I have a task that starts January 11, 2016 ends…
-
ver archivos adjuntos sin descargar
Los archivos adjuntos que se envian en una fila, el receptor para verlos necesita descargarlos primero en su computadora. Necesitamos ver los archivos adjuntos con un visulaizador rapido sin necesidad de descargar el archivo. A modo de ejemeplo, aplicaciones como google drive, disponen de visulaizadores rapidos, esta es la…
-
Uncompleted tasks can't start until today
I' ve just started trying to use Smartsheet as a project planning tool. I have created a Gantt chart for my project, and put in the resources. Where tasks are fully or partly completed I have put in the % Complete figure. The system does not seem to have adjusted the start and finish date of tasks that are not 100%…
