-
Intake form
Hi all! I have an intake form that collects request submissions from an approval form connected to sheet. Once the request is approved, I need to transfer collected data to individual vendor tracking sheets. I have the automation set up to copy row but it is copying ALL data collected. I don't want all data shared bc some…
-
stock amount update with order fulfilled
Hello Community I'm building stock management smartsheet, pls. see below simple example I'm looking formula to automate the process: I want to have one single entry in "supply to stock date" column: and when I enter "supply to stock date", I want the "order status" to be changed from "in order" to "supplied to stock" and…
-
Formula: Read Text Column to Fill Multi-Select Column
Hi everyone, What is the formula I can use in a Dropdown: Multi-Select column (Revision column below) to select options based on text that is typed in a Text column (Notes1). For example, if Notes1@row contains "+ Change Design" and/or "Change Material" in the cell under that column, what is the formula for a cell in the…
-
split multiple items to isolated columns in a new grid
Hi, In a main grid called 'Grid A', one column contains multiple items selected from a drop down list. For a display purpose, I would like to have these items shown in individual columns (one item sits in a column) in a new grid, called 'Grid B'. Would someone please share idea to sort it out? Thank you.😊
-
Count number of days in date range that fall in current week
Hi everyone, I have a number of project plans in Smartsheet and am trying to get a summary of how many task hours each person has assigned for the current week. The plans currently capture task Start Date, End Date, and number of hours required to complete the task. As some tasks will take multiple weeks to complete, I…
-
VLOOKUP Formula Help
Hi everyone, I have two sheets: one is a training requests log and the other is a feedback survey. What I am trying to do is pull the "motivation reason" from the Training Requests log to the Feedback Survey sheet. My idea for the criteria is: IF the "Name" and "Internal Course" (Training Log) match with the information…
-
Showing most recent milestone
Hi there, Im working on a project where I have series of checkbox inserted for each phases to completion. Upon completion, i'd like the current milestone column to capture the current phase check boxed, irregardless of multiple checkboxes selected. For example, if checkbox 1, 2 and 3 are checked, i'd like the current…
-
Collecting and Averaging survey score excluding ""N/A" as an answer
I have a roll-up sheet from a survey in another smart sheet. There are 12 questions and several Project managers that are being surveyed. I currently have 1 issue remaining. I can collect and average the survey scores for each project manager, unless the person completing the survey selected “N/A” as an option. My current…
-
INDEX/MATCH Help
Hi all, I created the following formula to search through another sheet and, if a location has submitted a row in the applicable month, it is supposed to check the box on our confirmation sheet. It worked for January (see below) but is not working for February. What am I doing wrong? =IFERROR(IF(INDEX({Month Name},…
-
Help getting the summary of my sheet
I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am using this formula: =COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + "…