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 …
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 Ch…
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 t…
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 fie…
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, t…
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 differe…
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…
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 curren…
Hi Smartsheet superusers! Ok, so I used Smartsheet with a previous employer for a few years and it's been about two years since I was really working in the system. My potential new employer uses it an…
I have data on a "copy of construction checklist" that has been shared to me. I am an admin to the shared copy of construction checklist. If the owner of the sheet, cycles data off the sheet due to co…