-
How to remove the zero in a formula cell
I have a sheet that I'm inputting data in using a form, and then generating a document to print. Not all columns/cells will have an input on every instance, however, every cell is accounted for within the document mapping. The issue I'm running into is I have a column that has a column formula, and every time I have a new…
-
How to make Parent helper column reflect values based on Children values with multiple conditions
I am very new at using formulas with hierarchy. I simply cannot figure this out or find a similar situation to manipulate the formula. I want the Parent value in helper column Parent Proficiency to be based on CHILDREN values in Proficiency column Levels: Untrained In Process Trained Proficient Preceptor Parent helper row…
-
Formula to Pull Data from Source Sheet if Criteria Matches a Name
Background: I have a sheet with a list of users assigned to specific tasks; users may be assigned multiple tasks. The users are in a contact column, and I have created a column that contains only the names of the users. I'm trying to create individual sheets for each user that contain the tasks only assigned to them but…
-
Smartsheets issue with Start and End TIMES - is there a way to utilize MS project to feed that info?
Hi! I have been using Smartsheets for the past 4 years, and I love this product; however, one downfall is there is no ability to have an auto updated Start and End TIMES down to the minute (not dates) based on predecessor. On my past project, this was no big deal; however, on my new project, I have been asked to track down…
-
Automatically adding new columns when customer fills out an order form
Basically, I am trying to create an order form for a customer to fill out and then we will view in Grid view. Basically, at this point, I have it laid out as the ss below. I want there to be an option to select how many items they will be needing, or add on as they think of them if possible. I only have these 3 rows which…
-
Need a condition to override other conditions in a formula
Hello, I need to show a percentage rate in one column based on a time of year in a different column, however, if there is a certain word in a third column, I need it to override the other conditions. Right now, the formula is: =IF([Program Term]@row = "Summer", 0.325, IF([Program Term]@row = "Academic Year", 0.499)) I need…
-
COUNTIFS question, stumped
I'm trying to count how many "Yes" is in the column (options are Yes and No). The column name is "Do you plan to stay overnight May 1st?" I feel like this is probably simple but I've been stuck on it for 2 weeks. HALP
-
Unable to convert a vlookup formula into values
I have multiple columns with column formulas built that do a lookup into another Smartsheet. Want to convert the lookup values into values in the workbook that I built the formulas in, and then delete the workbook that is currently being referenced to find lookup. I cannot figure out how to do it. I do not see an option to…
-
PMO Template Set: Suggestions for challenges with how Schedule Health is calculated?
I am struggling with how Schedule Health is calculated in the Project Plan that comes with the PMO template set – it seems misleading and not an accurate reflection of health because: After setting a Baseline, the Schedule Health is still calculated using Target End Date (which is likely a different date than what is in my…
-
Add multiple amounts together for multiple selections
I am trying to create a formula that can look at a column with multiple choices, put a number value for each option chosen and add them together for a total. So if they choose option A, amount is 400, option B, another 400, option C, 500, etc. the column would add those amounts together to get 1300. Here is what I have so…