-
Logic Project Plan
Hi , Need a help on the project plan logic related to Sch Health. The logic i am using on the schedule Health is not showing me the correct result. As you can see Start date is 06/01 and End Date is 06/30 the % Complete is 50% ideally it should be green because it just a week and the % complete is 50% Can any one help on…
-
I need help so that I can calculate a percentage of completion
Guys, I need some help. I am struggling with calculating the percentage of completion of the whole sheet based on how many tasks are Complete in the Status column, or maybe better said to calculate the completion percentage based on the Parents Status in the Status column. Thank you and I am waiting for your advice.
-
Need Help with an INDEX(Match) formula
Hello, I need some help sorting out an INDEX(match) formula that is not working despite my best efforts. It may be that I have been staring at it too long. I keep getting a No Match when I add "0" in search type, and I get the first value in my column when I add a "1" in search type. It seems ot be returning the first…
-
Formulas in Workspaces
A few questions: I recently transferred over some sheets to a workspace area and when I did, it appears that it cleared out any formulas or automation from those sheets. Is that how it should work? Did I not transfer it correctly? Since all my formulas are now gone, i've manually tried a few times to enter the formula that…
-
Using IF, FUNCTIONS (HAS, CONTAINS, etc.), and OR (for searched fields).
Greetings Team, I feel like I'm missing something simple on this one, but it's a general problem that I encounter a lot. For this question, I'm able to construct formulas that Smartsheet accepts, but the current version is long and more difficult to understand/manage from other users. This involves using IF, FUNCTIONS, and…
-
Can JOIN include a space as part of the end result?
After JOINing a series of cells, I need to include a space after "CSANe" but it keeps getting ignored. Certificate No. column is the JOINed result Cert # Preface is a formula. I tried ="CSANe " I tried adding the Spacer column with the formula =" " The space is always ignored. Is there any way to get the space to appear?
-
Check a box in Parent cell based on children cells
Hello, I need to check a box in a parent cell only when all children cells in that column have been checked. I will manually paste this formula into multiple parent cells in my sheet. The formula I tried did not work...Any guidance or tips on where I went wrong? My thought was if I gave the range of children cells, and…
-
Count if for multiple columns
Hi all, I'm trying to create a count if formula to find data in two columns. For instance I have two columns. One column is status and the other is for discipline. I am trying to count if the status is "complete" and the discipline is "marketing". I need the formula to tell me what is the total count in the Smartsheet.…
-
Formula help - Countifs, contains, and adding an OR function
Hi Smartsheet Experts: I am working on a formula and have gotten stuck. I have a countifs formula, and I need to change it to count customers with either Product A or Product B (some have both) - I can't figure out how to insert an "OR" function into the formula without breaking it. Right now the formula is actually…
-
Weird outcome with Large function
I am experiencing a weird scenario while trying to use the Large function. What I want to do is to get the two most recent dates from a column with numerous dates. Please check the sample datasheet: The Dates column contains the dates and I am showing the two most recent dates in the column Recent Dates. I am using the…