-
Showing Continuous Trend even with Gap Data
For context, I am trying to show month by month trend, but there are some months where there are no data. Right now, my trend column (#3) compares the data(Column #1) in the current row to the row right below it. For rows where the row below has no data, is there a formula to get it to skip the empty row and compare it to…
-
Calculating a Dollar Amount from Percentage and Total # column
I am trying to create a formula row that looks at the total dollar amount of a budget ($100,000) and breaks it out into dollar amounts based on percentages in another column. For example: Percent Allocation column/row has 73% in it, and I have a field with a total budget number ($100,000). I want to populate another column…
-
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…
