-
Verwalten und Sortieren von Zeitstempeln in Smartsheet
Dieser Lösungsbeitrag wurde basierend auf einem Leitfaden für bewährte Verfahren erstellt, der ursprünglich von @Kelly Moore entwickelt wurde. Den Originalbeitrag finden Sie hier: Converting a Text Timestamp into a Numeric Timestamp Value. Problem:Wenn Zeitstempel in Smartsheet importiert werden, müssen sie oft als…
-
Gestione e ordinamento delle marche temporali in Smartsheet
Questo post di soluzione è stato creato sulla base di una guida alle best practice originariamente sviluppata da @Kelly Moore. Può trovare il post originale qui: Converting a Text Timestamp into a Numeric Timestamp Value. Problema:ai fini dell'importazione in Smartsheet, le marche temporali devono essere spesso importate…
-
Smartsheetでのタイムスタンプの管理と並べ替え
このソリューションに関する投稿は、@Kelly Moore が独自に開発したベストプラクティスのガイドに基づいて作成されています。元の投稿はこちらでご覧いただけます: Converting a Text Timestamp into a Numeric Timestamp Value。 問題：タイムスタンプをSmartsheetにインポートするときは、多くの場合、形式を維持するためにテキストフィールドとしてインポートする必要があります。そのため、特に最近のデータポイントの順位付けや特定にタイムスタンプを使用する場合、データを時系列で並べ替えたり整理したりすることが複雑になる可能性があります。 解決策：…
-
Gérer et trier les horodatages dans Smartsheet
Cet article consacré à une solution a été créé sur la base d'un guide de bonnes pratiques élaboré à l'origine par @Kelly Moore. Vous pouvez trouver l'article original ici : Converting a Text Timestamp into a Numeric Timestamp Value. Problème : lorsque les horodatages sont importés dans Smartsheet, ils doivent souvent être…
-
Administrar y ordenar marcas de tiempo en Smartsheet
Esta publicación sobre una solución se basa en la guía de mejores prácticas desarrollada originalmente por @Kelly Moore. Puede encontrar la publicación original aquí: Converting a Text Timestamp into a Numeric Timestamp Value. Problema: Cuando las marcas de tiempo se importan a Smartsheet, a menudo deben ser importadas…
-
How do companies manage and document data flows in Smartsheet to ensure data integrity?
I’m new to Smartsheet and data meshing, and I’ve noticed that the original source data isn't always used consistently. For instance, someone might create a data mesh from a source to build their own sheet (Sheet B). Then, another person creates a data mesh from Sheet B, and this process continues. How do companies manage…
-
What is the best way to handle changes on assigned person?
Suppose one of my coworkers left the company and there is this new person coming in to fill the same position, same responsibility, etc. I want to make sure all of the shared sheets (not just the owned ones) and also all of the assigned cells transferred from the person who left to the new person. What is the best way for…
-
Resource Management by Smartsheet -- Good for Small Business?
Hello! I am helping a small high-end contractor optimize his business use of Smartsheet. His organization has a Business plan. He would like to be better able to track workloads of his organization week-to-week & also highlight when subs are overallocated. Wondering if RM is a good option (or if it would be overkill). His…
-
Inquiry How to vlookup
Hi Community, Hope all are doing well, I need to make Sheet 3 dynamic, i.e., if I add any data to Sheet 1 and Sheet 2, it should be merged using the same ticket number in One Raw.” Desire Result: Column: Ticket Number | Created Date | Assing By | Assing To | Assigned Date | Approver DATA : CH000000001 | MM-DD-YYYY | JUAN…
-
Identifying current data in DataTable
Does anyone have a good way to identify good records in DataTable? DataTables can be updated from an external data source using Data Shuttle but there is no way to automatically remove DataTable records that are no longer in the source data. This means DataTables will contain bad data. My current workaround is to include a…