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…
It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…
Hi all, Our org has dozens of workspaces and while we have moved more toward group-based permissions recently, I still have some legacy workspaces that were configured with dozens of individual user a…