-
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…
-
Trying to copy formulas from the Source Sheet to the target sheet using DataMesh
Hi, I've set up a configuration, that merges entries using copy from a source to a target sheet that is updated with the latest new rows. Copying of the data is working fine, however the formulas in the source sheet get lost in that process. Is there any way to avoid this? Background: I've an Excel sheet containing…
-
Using the OR and AND Function together
I have a checkbox that I need to have checked if the Due Date Field is less than today and the Status does not equal Completed or No Longer Required. I've tried multiple combinations of formulas and I have not been able to figure it out. I need some help. Here is the formula that I currently have. =IF(OR(AND([Due Date]15 <…
-
Percentage Formula
Has anyone built/used a formula to capture the percentage of specific responses in a series of questions? We're experimenting with Smartsheet Forms to be able to administer an exam. Each column would be a single-select dropdown of the multiple-choice exam question format. On the backend, we want there to be a formula…