-
A Single Formula to SUM a variable range of cells in a row
Hi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the row. If the number is 19, I want to sum the first 19 cells. The range is always contiguous, and the cells to be summed always…
-
How to capture a value from multi-select column
Which formula works better to find out if a value exists in a multi select dropdown column? I have responses collected from a survey and one of the column was multi-select dropdown list type column. I'm trying to separate out the selection values and adding them in a separate sheet (so using cross sheet reference). Have…
-
Formula to add 1
I am trying to figure out a formula that will add 1 to the Parent [DMR #] The below will Place a "1" at the end but I need to add count by one Like this DMR5575-1 DMR5575-2 DMR5575-3 =IF(Level1 = 0, [DMR #]1, PARENT([DMR #]1) + "-" + 1)
-
Need help with a VLOOKUP and MATCH formula
Hi there, I confess I get so lost when it comes to formulas. I've read through various community discussions and help pages, but for some reason I just cannot get the logic of creating a formula. In sheet 1 I have a column for "Freelancer." In sheet 2, I have a one column for the "Freelancer" and one column for "Payee,"…
-
Is there a way to pull only the children into the report?
I am trying to have a report that shows only the lowest indented children in it. I am working on a sheet that has 4 level of indents. Workstream (indent 0), Project (indent 1), Milestone (indent 2) and Activities (indent 3). The report needs to include activities only and not any of its parents. Please let me know if there…
-
Formula autofill to the next rows in a sheet when using hierarchies
Has anyone had any success with maneuvering around the fact that new parent rows created by a form and added to the bottom of a sheet will not inherit the formulas of the row above? Here's the note from the Smartsheet help: NOTE: Form submissions will always be fully outdented. If the last row in the sheet is indented in…
-
How do I get a sumif working with two date columns as comparison conditions?
Trying to get this formula to work but kind of new to Smartsheet. =sumifs(metres:metres, completed date:completed date, @cell<required date@cell) I don't know I should be using a flag column, there's already a fair bit of data knocking around and I would rather just get this to work for the sheet summary field.…
-
Calculate number of days in a month
I'm trying to build a custom calendar in a sheet (Calendar app or view doesn't work in our use case), I want to calculate total number of days in a given month, but so far the day, date formulae need two set of dates. I know one way of simply declaring the values in a column and use it that way but I was wondering if…
-
Combining IF Formula - Is This Possible?
Hello, I'm working on a formula that will trigger a status of "complete" based on a Task Reviewed column. =IF([Task Reviewed]5883 = 1, "Complete", PARENT()) I am trying to combine the formula with another one that will trigger the same status as the parent row when the cell above it is complete. =IF(Status5882 =…
-
Suggestions for display of a calendar
Hello, I am working to create a call room reservation request system for our hospital. Smartsheets is working wonderfully for this, I'm just stuck with one little dilemma. The people who review registrations, like to be able to view the month at glance for all the rooms reserved. The screenshot below shows our current…