-
DropDown list - from another Sheet
hello , i have a huge list to be added in Dropdown, Does Smartsheet have option to pull the Dropdown from another sheet, (similar to excel spreadsheet).? Since the list will be Dynamic, editing the downdrop list everytime is time consuming. thanks Vasanth
-
Countif when multiple values
I have a form that allows users to multi select. I have a metrics sheet that counts the number of times a selection appears, however, it's only working for those that only had a single value selected. Multi-select are NOT being counted. Is there a way to get counts when there are multiple values in the same cell? Here's…
-
IFERROR and NETWORKDAY formula
Hi, I have a source sheet with two date columns: Date of Request and Date of Completion. I am using a summary sheet to create a dashboard and have used this column formula to cross reference the source sheet to find the number of working days between the two dates: =IFERROR(NETWORKDAYS([SourcesheetRange1],…
-
How can I display a summary of all projects that each team member is assigned?
I have a spreadsheet that includes a column "Project Name" (free text, primary column) and then a column "Assigned to this Project" which is a multi-select drop down with 28 names. This list is all members of a team that could potentially be assigned to the project. The number of assignees varies between 3 and 8 team…
-
Get data from another row - matching single value with multible dropdown values
Hi, I have this big sheet (actually two, but I cannot even get it to work in one). I want to return the value in column16, men I can find the value (doesn't have to be a multible select column) - WHEN I can find the single value within the multible-dropdown values. I have searched and tried a lot, but I cannot get it to…
-
Hello I am trying to create a formula that returns a specific date when a dropdown selection is made
class requested start date Jan 13, 2025 - July 14, 2025 Oconomowoc, WI Jan 13, 2025 - July 11, 2025 Huntsville, AL (new site) Feb 10, 2025 - Aug 11, 2025 Amsterdam, NY Mar 24, 2025 - Sept 22, 2025 Fontana, CA Apr 21, 2025 - Oct 20, 2025 Oconomowoc, WI May 13, 2025 - Nov 17, 2025 Huntsville, AL Jun 16, 2025 - Dec 15, 2025…
-
Need help with MATCH
Hi there! Please help! I have a distribution list (Names of Users) that is feeding into different trackers. I am using an auto row column labeled "ID" and a helper column labeled "RowNum" with this formula =MATCH(ID@row, ID:ID, 0). The issue is that I completely missed a user and so I made the mistake of entering a row in…
-
Formula (if this is and date beyond, check flag)
Help with this formula (generated through AI). I need it to look at this cell (if it is blank) and another cell (date) is greater than 3 months, turn the FLAG on in ____ (cell). I am missing this other cell name, I believe. Cell/Field is called Protocol FLAG. =IF(ISBLANK([DRAFT Protocol Received (Date)]@row) AND…
-
[Formula Help] - Countif department and not blank?
Hi everyone - I'm stuck trying to figure out how to format this question better. I'm working on building a dashboard for some reporting. The dashboard captures metrics from different quarters. (Average number of training hours). I'm trying to figure out how to set up a formula so that empty cells aren't counted as part of…
-
Index Match formula = unparseable
Very new user to Smartsheet. Two questions: What formula change needs made to not get error? Would it be better to do index and collect? Sheet: Fields Appointments: Appt #, Date, Time, MRN, LLL Language, MRN Language lookup (field populating) MRN Additional Information: MRN Master, MRN Language, Eff date, Last updated…
