-
Help setting up formula IF
Hi there, I'm trying to set up an IF formula to pull the Month from the "due date" row. I've been using the following formula: IF(MONTH(DATE@row) = 1, "January", IF(MONTH(DATE@row) = 2, "February"....) Although we have a cut off date which is the 25th of every month. All projects due after this date should be pushed to the…
-
Restricting Text/Number Columns to a Format
Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful to have, especially with the amount of forms that I, along with my Smartsheet…
-
Date 6 months out (to the day)
Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also new at SS, so I am just now learning syntex, etc., regarding functions and formulas.…
-
Calculate buffer for a task/chain before it affects the project completion date?
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 trying to leverage successors function to see if i can determine the buffer, but no matter what i try it just gives me the…
-
Rolling 12-months formula: % of projects completed on time
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 Status is Completed. The rolling 12-months will be based on the Actual Complete Date column. Below is is the data. So for the…
-
Is there a work around for trying to use CONTAINS() or HAS() within collect()?
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 multi select column (I have also tried it just text) off all the dates each work type has work. I am then on a separate…
-
Sheet Summary CountIFS + Date Range
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 converted over from Google Form/Sheets & several formatting changes had to be made in August. (Probably issue #1) Co-workers…
-
Variance on task list
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 time, I want to show 0. I have been trying to use this formula =NETWORKDAYS([Due Date]@row, [Actual Finish]@row) - 1 This…
-
Is there a way to easily/quickly hyperlink 100's of sheets.
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 and go directly to that person's individual sheet. I understand that the desired effect can be obtained by running a report…
-
PMO Template Set - Need another level of folders
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 do need is the ability for each PM to see a dashboard for just the projects they are managing. In the template set there is a…