Trying to calculate the buffer a task or chain of tasks has before it affects the project completion date. iscritical allows me to determine if on critical path, in which case its 0 days buffer. I'm t…
I am looking for a formula that will calculate the % of projects completed on time when the actual complete date is on or before the scheduled complete over a rolling 12-month period and the Project S…
I am trying to summarize my projects data that is assigned to a work type, dates/weeks specifically and then count it by week or singe day. Can't figure it out. I have a summary sheet that brings in a…
Hi All, Need some assistance. Found a great post & this on the subject but was not able to get my formulas to work. Hoping the group can help. I have 1 working the other is not. Background: Form was c…
I have a sheet that is a running list of tasks that gets added to weekly. I am looking to figure out how to show how early, or late, a task is completed in relation to the due date. If the task is on …
I am running into an issue where it is desired that 100's of sheets in a workspace have an individual hyperlink on a separate sheet. The desire is that in card view, they can click on the hyperlink an…
Hello Gurus, We are in the process of implementing the Smartsheet PMO solution from the template set. We've done some customizations and we think this is really going to meet our needs. One thing we d…
Let's assume for a second that I have a file that is titled "Project Info". I also have a folder called "Projects". Every file in the project folder has the same columns though the project names are d…
I'd like to automate the copying of a row into a secondary sheet when a cell is updated. Then delete any older versions, on the secondary sheet. I have already created a system column to create projec…
I want to take a Smartsheet Dashboard that is interactive and put it as a web part within MS SharePoint 2016 site. I use the page viewer webpart and provide the web page link offered up when I publish…
