-
Question about embedded webform and filtered sheet in confluence
Dear all, I did some research about the following topic but somehow got stucked and every helping hand is appreciated. What is the current status: Currently we are using smartsheet (lets call it "project_overview") to keep track on all our projects. After a few years this list is quite big (around 700 rows) so we are…
-
ability to "nudge" bars in gantt view
Wouldn't it be nice, when laying out a project in gantt mode, to be able to just use the arrow keys to "nudge" the bars left and right in order to tweak the final details? Has anyone figured out how to do this?
-
Finish to Start dependency
I have a question that I am embarrassed to ask. I thought that I would know the answer with no doubt . If you build a task that is dependent on the completion of a previous task with a Finish to Start relationship (very standard) and the previous task ends on April 9th (a Monday) shouldn't the next task (the dependent…
-
if formula
Hi, I'm in need of a little help. I am trying to create a spreadsheet that allows me to calculate the reimbursement amount. For instance, if the employee returns a receipt over the allowance amount then the total would be the allowance amount. If it's less than the allowance amount then it equals the receipt amount. It…
-
Hierarchy Rollup
Does anyone know the formula for the hierarchy rollup of children to parent. I want the % complete to be calculated automatically for the parent, based on the % complete of all the children. Apparently it is supposed to happen automatically, but it is not for me. I'd like to add it manually. Thanks
-
Subtasks in CardView
Hi Their I currently have 4 sheets which represent 4 departments in a card view ( running multiple kanbans ), off a card may come a subtask that needs to be delivered by another team. i am creating the subtask which creates the additional card on the main sheet, but when i move the subtask to the relevant department (…
-
Count of cross-sheet formulas in a sheet
Given the limit of 100 cross-sheet references per sheet, is there any way of seeing the total number of cross-sheet references already in place for a given sheet? My use case - I've got a handful of sheets reaching the maximum amount on each, all to support rollup metrics for executive reporting. My formulas are lengthy…
-
Summary Row Card View
Hello, I cannot find any resources showing how to create a summary row card in card view. My lanes are based on stages of a project which is selected through a drop down on each row. I would like to total the NPV of each project that is in that stage (NPV is one of the columns in my sheet). How do I do this? Thanks!
-
Predecessor links disappearing when printing in PDF
Hello members, Need a quick help. I have a project and in the gnatt view the predecessor links are visible: See screen shot Gnatt mode. When I want to print this gnatt chart, the links disappear in the PDF mode. See screen shot PDF mode. Can someone tell me what am I doing wrong as I would like to see the predecessor links…
-
Is it possible to display 2 different date range diplays in the Gantt Chart?
Hi, In the Gantt Chart, is there a functionality or a way that we can see 2 different date range displays? For example for a project tracker, 1st date range would be the planned start date and planned end date and the 2nd would be the actual start date and the actual end date so it would look like 2 bars (with 2 different…