-
Absolute Sheet References for use in formulas across multiple sheets
We use our own variation of the Project Management Template Set, and our PMs copy the folder when they are initiating a new project. We would like to include a formula in the project plan template for which the reference to another sheet will persist and work in the copy. This will help so that the PM doesn't have to…
-
Project Cutover Planning
I have been working to transition my Excel based cutover plan to Smartsheet. I have read the posts about the challenges with Date and Time and having the ability to calculate duration with these challenges. Has anyone identified a truly viable option to track tasks at the minute, hour and day level for both child and…
-
IF AND OR not working properly, last IF not triggering anything
Please help me figure out why this is not working: =IF([% Complete]@row = 1, "Completed", IF(AND([Start Date]@row <= TODAY(60), [% Complete]@row = 0), "Not Started", IF(AND(NOT(ISBLANK([Start Date]@row )), NOT(ISBLANK([% Complete]@row ))), "In Progress", IF(AND([Start Date]@row >= TODAY(61), [% Complete]@row = 0),…
-
Best Practice Inquiry
Good morning, We have an expense report that I pull from our system 2 times a month and put into Smartsheet. I have about 100 Department IDs I share it to split between different 10 bureaus and 4 centers. I am trying to find a good way of splitting up the information. Currently I have 10 grids for the different bureaus…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
-
日別タスクの集計方法について
martsheetでEVMを実現したいと考えています。 しかし、各タスクの日ごとの稼働実績の集計方法に悩んでいます。 現状は通常のWBS方式でタスクを管理しています。タスクごとに「開始日・終了日・計画工数」を持たせ、稼働したタスクごとに実績工数を日ごとに入力したいと考えています。 ■やりたいこと ・各タスクの稼働実績を集計したい・さらに日ごとの合計（全タスク合計）を出したい ■イメージ 【入力（縦持ち）】 日付 | タスク | 工数 10/1 | タスク① | 5.5 10/1 | タスク② | 6.0 10/2 | タスク① | 6.0 10/2 | タスク② | 3.0 【出力（集計結果）】 日付 | タスク① | タスク② | 合計…
-
Editing rows using forms or some other android UI
I'm a freelancer, and I want to use smartsheet to schedule jobs and do basic accounting. I have a 'new job' form to create a row with customer and job info. I need a way to then add more data to that same row later, once the job is completed (total price, material cost, etc). Is there a way to do this with a…
-
Creating a KPI Metric for a specific Project dashboard then up in the Portfolio Dashboard
I'm trying to create a KPI for Client attended meetings. We have 32 weekly meetings and a sheet with a Yes or No for Client attendance. I created a sheet but want to add a widget in the Project Dashboard then take that up into the Portfolio Dashboard. I would like both to be a colored percentage pie chart for Yes and No on…
-
Multi-Project Gantt Chart with 1 Swimlane Per Project
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
-
Automate when cell has contact added to remove all Pending Update Request for that row
When a form is filled out, and a row is added to my sheet, I have automation send to 3 recipients to update the "Owner" field. I want that Update Request to clear for all users and the whole row when an Owner/Contact has been added either through the button it sends/updates with or if anyone goes in and updates the…