-
Consejos para usar comentarios en Smartsheet.
¿Con qué frecuencia utiliza la función de comentarios dentro de las hojas, informes y espacios de trabajo de su Smartsheet? Nos gustaría mostrarle algunos consejos sobre cómo usar comentarios para una comunicación efectiva. La función de comentarios está en el panel de conversación, a la izquierda de su hoja. Para agregar…
-
Recording Most Recent Step in a Process
Let's say I have a three-step process that I perform many times: Draft, Review, Publish. (This is a simplistic version of more complex repeated processes.) For each step I have a checkbox column. For each iteration, I create a new row in SmartSheet. I would like to see the status all current iterations in Card view, so I…
-
Smartsheetでコメントを使用するためのヒント。
Smartsheetのシート、レポート、ワークスペース内でコメント機能を使用する頻度はどのくらいですか？効果的なコミュニケーションを図るためのコメント活用のヒントをご紹介します。 コメント機能は、シートの左側にある会話パネルにあります。 シートまたはレポートにコメントを追加する方法 会話パネルに移動します。 ［コメント］ボックスに、コメントを入力します。 ［コメントの投稿］を選択します。 ワークスペースにコメントを追加するには ［コメント］ダイアログに移動します。 ［コメント］ボックスに、コメントを入力します。 ［コメントの投稿］を選択します。 コメントを活用するヒントとメリットをご紹介します。…
-
Best practice to manage dynamic views without Content Centre?
Hi, My agency doesn't have access to Content Centre. What is the next best practice to 'retire' rather than delete a set of Dynamic Views, please? I'm finding that the list is becoming unwieldy but don't want to delete the DVs until I know they won't be required again.
-
Sheet setup for scalable data
Looking for a best practice to set up a scalable (target vs. actual, month-over-month) sheet - There are 15 specific varying metrics (e.g. numbers, $, %) collected monthly by different people. Each metric will require both actuals for the prior month and a target for the next month. I would like to show both monthly…
-
How to input data into target sheet from a source without a unique ID
For context, I am mining public clinicaltrials.gov records to associate unique trial records with results publications. There are often multiple results publications linked to an individual trial record. I have a sheet of my institutional records, each record has its own row and is uniquely identified by a national…
-
Year-to-year best practices when it comes to metrics based on dates?
Greetings- I need some advice in regards to best practices when it comes to tracking multiple years and what to do when one year ends. For example, my SS below tracks submissions via the form by month and year using the formula below for January. =COUNTIFS({Community Engagement Request Range 1}, "1", {Community Engagement…
-
Q: Share to Personal contact "group" in Outlook
Hello Smartsheet Community, How-to Question... Co-worker has a personal contact "group" in Outlook with over 100 people in the group. This is not a "distribution list" and not a company-wide "email group" for the directory - and we don't want to put it there. Also, we're not "admin" for the whole organization - so not…
-
Best Practice for Capturing Project Info on PM project plan
My team is using the Project Management Office template set. I love the template set but I saw this Project Information section on a different project template and I like the idea. I added it to the Project Plan template in our PMO, but I can't figure out how to use it or if there's a better way to capture this…
-
Count If AND
Hi! I am trying to build a formula in which I can count an item from a list as long as it meets 2 criteria: 1- Item submission is in JANUARY 2- A dropdown selection is "No" I truly cannot wrap my head around making the right formula so it gives me the appropriate result as I do not know how to build a count IF formula that…
