-
Formula returning 0
Hi Can anyone help me with this formula? Should be really simple, but i am having an off day it seems! The formula is looking for any elitebook g3 devices that are in northampton, but gives me the result of 0 instead of the correct number? Any ideas?
-
Automatically Track Inventory Usage
I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form? I have two sheets: one is the…
-
Formula for 2 columns - checkbox and a date range
Hi there - newbie here. Looking for help with a formula. I am trying to drive a metric which shows the percentage of activities on 'THD Brands' in the past week. The 'THD Brand' column is a checkbox, so essentially I need to count anything that is ticked in this column, and also the 'Last met?' column has a date within the…
-
IF AND INDEX MATCH to pull the correct row based on criteria
Hello all, I am struggling to come up with the correct formula to pull the right information between master sheet and personal tracker and I wondered if you can help. My logic for creating the formulas is not the very best. What I'm essentially trying to do is pull the right start/end date and budgeted hours from the…
-
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?