-
Return multiple values from one search criteria
Hi! I'm fairly new to Smartsheet formulas and have reviewed the community posts trying to find help to my question. I am trying to pull PTO requests from one sheet to another. VLOOKUP has always been a friend, but unfortunately does not pull multiple values. My lookup criteria is a single date, (ex 2/28/24) but there can…
-
Modified by column is being filled in with "automations@smartsheet.com
I need to know who last "Checked" a box in a column. After the box is checked, there are several automations that happen. Next to the box, is a column that I want to log the user who checked the box. But since there are automations, it's removing the users name and replacing with "automations@smartsheet.com". Can this be…
-
Mandatory field in Smartsheet
Hi, I have a Change Request Smartsheet, and I need to have the 'estimation completion date' collum as a mandatory to be filled by the requester. How can I implement this?
-
Display most recent comment of Child Rows in parent row.
Hello, I'm looking for assistance in creating a formula that could be applied to a whole column that would display the most recent comment of a child row in the parent row. This would help to see the most recent update to a project at a glance in reports. After the screenshot, I made another column to collect the data, but…
-
Hello,
I had a formula that was working all through the trials but then right before the roll out it stopped working! In one cell there's a column that Auto counts Responses no big deal there. In a cell in a different column =MAX([Row ID]:[Row ID]) // this counts the largest value so I can record the latest response In another…
-
Progress % based on status with cell linking
Hi I have two sheets, one acts as a master file for top level view only, the other is a more working doc. On the working doc, I have added a progress column, calculating the percentage of progress of the project based on the progress i.e. =IF([Activity Status *]@row = "Not Started", "0%", IF([Activity Status *]@row = "On…
-
Populate Cell Value based on Defined List
Hi, Im trying to figure out the below scenario. SHEET 1 - ROW 1 - CELL 1 Drop Down list of Fruit SHEET 1 - ROW 1 - CELL 2 (DESCRIPTION) EMPTY SHEET 1 - ROW 1 - CELL 3 (PRICE) EMPTY SHEET 2 SOURCE SHEET Scenario Open SHEET 1, Click CELL 1, choose APPLES. CELL 2 populates with "GREEN APPLES" mapped from SHEET 2, CELL 3…
-
Countif checkbox not checked and frequency is not adhoc request or upon request.
I'm having trouble with a countif formula returning unparsable. I working with a metric sheet that counts tasks on another sheet where an Adhoc Request checkbox is not checked, and the task in the other sheet also has a frequency (dropdown list) that IS NOT "adhoc request" or "upon request". What am I missing here.…
-
Flag a case in one sheet if it is in a certain status on another sheet
Hey Y'all, I need some formula help. Here's what I'm trying to accomplish: If Case 1234 is in “Review” status on Sheet A, and someone enters Case 1234 on Sheet B, I want to flag Case 1234 on Sheet B so that no one takes action on it while it is still in a review process on Sheet A. If Case 1234 is in any status other than…
-
Index Match with multiple sheet references Help.
I am trying to use the index/match function across multiple reference sheets. (Formula #1 works but just across on reference sheet) =INDEX({Team X Email list}, MATCH([Five9 ID]@row, {Team X Five9 Username}, 0)) (Formula #2 does not work across multiple reference sheets) =INDEX({Team X Email list}, MATCH([Five9 ID]@row,…