-
Change the value of a cell from the formula results of another cell
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete…
-
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…
-
F4 funtion in excel
Could someone tell me what the equivalent in smartsheet is for the F4 funtion in excel that fixes the cells within a formula?
-
Eliminate auto-numbering from child rows
Good afternoon, We are trying to create parent/child rows where only the parents has an auto-number, not the child. Is this possible? Perhaps we just need to use a formatting option instead of the column type as an auto-number. Blessings, Loann
-
Formula on Modified Date to Determine Days Since Last Modified
My sheet has a column for last modified. I'd like another column to give me the results from =today()-last modified so I can easily see how long its been since a row has been changed. If I use the formula above I get some decimal. If I use =(today()+"")-last modified I get an error. Any way I can do this?
-
Gantt Chart Dependency Settings - Choosing new date range display columns deletes the formulas in th
Hi; When I choose columns (which includes formulas) for the "Start date column" and "End date column" in the "Edit Gantt Settings->Dependency Settings" dialog, formulas in the cells of newly selected columns ("Date range display" options) are being deleted automatically. Is there a way to prevent this? Note: I need to swap…
-
duration adjusted for resource Allocation %
We would like to be able to keep track of absolute effort (in days), but the Duration column that effects End Date, should be adjusted for Allocation %. So if a resource is allocated 10% on a task estimated at 1 day, it would actually take 10 days (duration) of wall clock time. May be a formula where Duration = Effort…
-
Having problems with sums
Hello. I am trying to add some totals in a column. It's a pretty simple thing that I do in Excel all the time. I am just clicking on a few cells in a column to be part of a total. However, after a do about 3-4 cells, it stops working and the cell with the total says #UNEXPECTED OPERATOR. Any idea what I'm doing wrong?…
-
Is it possible to conditionally format a row based on the status of it's dependencies?
Hi, I'd like to colour a row, or perhaps set a column based on the status of that rows dependencies. Does anyone know if this is possible? Thanks in advance, Tom
-
Can you create Custom Functions in SS like you can in Excel with VBA programming language?
Can you create Custom Functions in SS like you can in Excel with VBA programming language?