Hi all, I searched and I didn't find anything for this so I am hoping I did not just miss this. We are trying to tie our data into Microstrategy for more visualization options. We are using the Live D…
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 i…
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…
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 th…
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 wou…
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 …
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 Sma…
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 anothe…
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…
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-scre…
