-
Tasks with multiple start and completed stages before FINAL completion
Hello! I'm building a sheet to track multiple tasks. Each task (FILE) has different stages of completion (PROCESS/INTAKE, Research, Drafting, Reviewing and Finalizing). Each stage has an ASSIGNED TO contact and COMPLETED date. The Finalizing date will be the FINAL/END date. We want to track turnaround time per ASSIGNED TO…
-
iCal to Outlook - Filtered Calendar?
I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible? I understand it can't be done from a report. I also…
-
Multi-tier reporting in Control Center?
I am looking for a way to set up a report in my parent blueprint so that: Every time a new child project is provisioned, a specific sheet from that project is added to the report at the parent level. The parent report is a collection of that sheet in all child projects. Things I tried that didn't work: -Adding the child…
-
Show empty lanes in timeline view of report
Hi, I am running timelines on a master sheet for high level tracking of a few different things. Rather than adjusting the timeline settings to get each view needed, I’ve created a set of reports set to timeline that are permanently grouped and filtered as needed. I want to use the “Show empty lanes” option under Group in…
-
How are you scaling a PMO in Smartsheet across multiple departments/workspaces?
Hello everyone! We have a great structure within our own department and looking to expand across our firm. I am looking for insights on how you manage cross‑department projects when each department has its own workspace? Interested in workspace structure and reporting best practices. I appreciate the help.
-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
-
Add Stacked Area Chart type to Dashboards
Please add the Stacked Area chart type to Dashboards (available in Excel)
-
What is the best practice to manage adding features and changes to Smartsheet?
We are working on adding testing and change management to our Smartsheet instance. What are best practices for managing changes, and having a Dev to Test to Prod style workflow? How are others managing test data and automations that are not in production yet? We are working to add additional functions to our projects,…
-
ODBC Smart Sheet Connector für Excel 64Bit ist extrem langsam ?
Ich lese Daten aus 25 Smartsheets ins Excel ein. Die Daten werden in 5 Listen zusammengefasst. Imm Anschluss mit Power Pivot in einem Datenmodell verarbeitet. Es geht um eine Anzahl von in Summe 30.000 Datensätzen. Der Aktualisierungsvorgang, bis Excel die Daten Erhält dauert eine Stunde. Kann man den ODBC Konnector…
-
入出金履歴管理の設計について
個人単位の入出金管理について、設計の相談です。 Aさん〜Gさんなど複数名の入出金を管理しており、
以下のような構成を考えています。 ・シート①：全員分の入出金履歴（1行＝1取引） https://app.smartsheet.com/b/publish?EQBCT=63bab2005ccb46e5922aac9efd9bf560 ・シート②：名簿（個人マスタ） → 名簿側で現在の残高（SUM）を確認できるようにしています。 ・レポート①：個別の入出金履歴 https://app.smartsheet.com/b/publish?EQBCT=f090df15bdae4df894da7fc4ae26dfa2…