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…
I created a external ticketing system in smartsheet and set up automation for a message and survey to be sent to the person who submitted the ticket. Ticket submissions will come from people outside o…
Our teams love to communicate updates on their Smartsheets, but I'm wondering what the options are to copy/export these conversations and attachments. We'd like to archive the information into the pro…