-
Use a Lookup to Return Multiple Matches?
What replaces/is equal to the "row function"? I am trying to look up data with various criteria and array those multiple matches into separate cells? Using the article and formula below, I tested it in excel with my data and it worked.....I just cant translate here. Can you use the example below as the demo when showing…
-
Formulas will be the death of me-
Firstly, formulas will be the death of me. My coworker wants to to do this- If the overall plan is 25% complete and 25% through the duration = green If the overall plan is 50% complete and 50% through the duration = green If the overall plan is 75% complete and 75% through the duration = green If the overall plan is 100%…
-
Link to sign out after form submittal?
I have a form that users will be submitting whenever they remove an item from the Supply Room. The form will capture which item was removed, the quantity removed, and who removed it. I am capturing the "who" by forcing the user to log into Smartsheet when they access the form link. However, there is no way for them to log…
-
Month to date formula
Hi, Can anyone please suggest with a "month to date" formula that I can use in my sheet that is set up as shown in the attachment? I have a column that lists down all the dates in the year 2020. I would like to insert the formula in the checkbox column such that if the criteria is month to date criteria is met, the box…
-
DataMesh - Updating ONLY new lines
Hi - we get two-halves of requests from separate parties, and I'm using DataMesh to link to things based on a Unique ID. Once the second half of the request is in the sheet, I don't need to update it again. Right now, my DataMesh setup is updating that row anyway - is there any way to ignore "old" or existing requests?
-
Combining Dates For a "Sort By Date"
I have an interesting scenario where I am combining 3 SmartSheets into 1, and this happens in three phases: First, someone initiates a request by submitting a request through a form into the first Smart Sheet. When they submit the request, the request is simultaneously copied over to a "Master Sheet." When it does this, it…
-
Contains Formula
I currently have a formula that looks to see if a specific phrase is contained within a range of cells: =IF(CONTAINS("Apple", Fruit1:Test1), "Fruit") Is there a way to have the formula look for another phrase as well? ie) =IF(CONTAINS("Apple" or "Orange", Fruit1:Test1), "Fruit") or something along those lines?
-
Automated Workflow Not Working
I set up a simple workflow. Once someone writes their initials in a column, it should move the row to another sheet. Except it is not moving the row to the other sheet. But when I look at the activity logs from both sheets, it says that a row has been moved from the source sheet and the destination sheet says a row has…
-
Webinar Recording Available: Create dynamic forms with conditional logic
Missed the webinar? Review the recording in the Smartsheet Learning Center. In this webinar, we introduce you to enhancements for Smartsheet forms, including how to: - Create forms using the full-screen form builder - Customize forms using conditional logic to dynamically show questions based on form responses - Take…
-
COUNTIF CHILDREN, Numbering Each Child
I am looking to create a count formula that counts only the Children and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula, =COUNTIF(CHILDREN(), 0) outputs the number of Children in the Parent cell, but leaves a "0" in each Child…