-
WBS Formula Question
I was hoping to get some help with a question regarding the WBS template from SmartSheet I found this template very helpful, and I would like to use it for my projects, but I need a little assistance with modifying the formula. I am not sure if this same setup can be used when the project tasks don't start on the first…
-
Formula for parent arrow to change based on the average child arrows
Hi all - I need help with formula to average the arrows and show the appropriate arrow based on that average, i.e. if majority of arrows are down, then the arrow in the orange section would be red, etc. Hope this makes sense.
-
Overlapping Flag Checkbox
Hello, I have created an internal communications form for our executive team to view the messages being pushed to our employees. We have the capability to send messages in a variety of ways, and I want to flag any message that is overlapping in delivery method and date range. So if the delivery method is the same and the…
-
Feeding individual sheets into one report for tracking. Please Help?
I have several projects (individual sheets) and I would like them to feed into one report so a team of people who need to overview all these projects at once can track them (mostly by looking at calendar). Can anyone give advice on how to do that?
-
Formula help please
Hi community - I am using this formula in the 'Planned progress' column of my projects: But it returns more than 100% when the date is past todays date (see example below). So I need to add to the formula - if today's date is after the planned end date, the planned progress should always be 100% (and never more than 100%).…
-
Is there a way to obscure partial name with stars
For example, is it possible to obscure someone's name or ID after say: 2 characters as a helper column? I.e Smith: Sm*** I.e. G12345678: G1****** or obscure only last two characters I.e Smith: ***th I.e ******78
-
Return First Non Blank Value within Children Range
Hi, I am currently getting a circular reference error with the formula below. What I am trying to gather is the first nonblank value within the children of a reference Parent Row. =IF([Company Name]@row <> "", INDEX(COLLECT(CHILDREN([Company Name]@row), CHILDREN([Company Name]@row), @cell <> "", CHILDREN([Company…
-
Formula to Count Across Rows
Hello! Checking to see if there is a way to count across rows rather than down columns. I would like to be able to identify how many times over the year the report was either sent on time, late, or not at all. Screenshot provided for reference. Thank you!
-
If/Then Formula with Projected Dates
I am looking to create an if/then formula for the below. I have 2 columns (projected start and projected complete) and I am trying to calculate the projected complete date for a project, but it is dependent on tier levels. I am not quite sure how to tie in the number of days the project will take into the formula. For…
-
Turn Rolling 12 Month report into Rolling 24 Month Report
Using help from a discussion on Smartsheet Community, I have managed to create a rolling 12 month report, using the following formulas Month: =IF(MONTH(TODAY()) - [M1]$1 < 1, MONTH(TODAY()) + (12 - [M1]$1), MONTH(TODAY()) - [M1]$1) Year: =IF(MONTH(TODAY()) - [M1]$1 < 1, YEAR(TODAY()) - 1, YEAR(TODAY())) However, if I…