-
Predecessors shift by 1 when export to Excel
Rows are numbered starting at 1 in the actual smartsheet view, and when it exports to Excel row number 1 is now the header, which causes the predecessor references to be wrong. I wonder if the fix to this would be to have an actual Row ID column in smartsheet in addition to the row reference? Another option is to prompt in…
-
Gnatt View print
Dear All, I have a quite a large program plan. To have a level one plan, I have a column with a check box to indicate what needs to be shown in the Level 1 plan. On filtering the Checkbox the Gnatt Chart view shows the dependency links, however when I export the same to PDF view the dependency links disappear? I have tired…
-
Overthinking nesting Formulas
I'm sure I am over thinking it, but I can't get these two to nest together to save some space... =[2]2 * [2]3 =IF([2]4 > 9.1, SUM([2]4 - 9), IF([2]4 < 9.1, [2]4)) Basically I want to multiply 2 rows together, then if it is greater than 9.1, I want it to subtract 9 and reflect that value, but if it is less than 9.1 I want…
-
IFNUMBER formula, help!
Good morning all, I am trying to create a formula that essentially does a planned budget value - actual budget value to get the "budget variance" but only if there is a number in the actual budget field. Any suggestions? Right now it is only: =[Budget Planned]26 - [Budget Actual]26 But when we have no actual numbers in…
-
Getting cell history of all rows (say 10,000)rows in a smartsheet
How to get cell history of all rows in a smartsheet without any error (rate limiting error).Using python code.
-
Syncing dates
Hello, I am new to SmartSheet I have set up a gantt view for a project and during the project we have had time slip. I would like to adjust the date for one of the items mid way through the project, then have all tasks after that to move on by the same amount of time. Is there an easy way to do this. Look forward to…
-
Different sheets under one project
Hallo Smartsheet communit, I am new to smartsheet, however, I am not familiar with everything as I am still learning abut it. I would like to find out if it is possible in smartsheet to create different sheets on one workbook as in Excel. I would like to create four sheets and link them with formulas. I am able to do that…
-
IF statement to update RAG status
Hi there, I would like to update my RAG Status icons (Green, Red, Yellow, and Grey balls) using a formula based on Due Date, Revised Due Date, and Submission Date inputs. My formula is as follows, and currently generates a #INVALID error message: =IF([Submission Date]1 > 0, "Green", IF([Revised Due Date]1 - [Due Date]1 >…
-
Tracking Financials on a weekly basis appose to monthly
Hi, We currently track our financials on a monthly basis project by project. We would like to track the resources on a weekly basis to calculate how much they cost weekly. Is there anybody that currently does this and could help us change our financials sheet from monthly to weekly? Kind regards PMO
-
Embed Dashboard into Email
Hello, is it possible to publish a dashboard and embed it into an email somehow?
