-
Auto-Populating Field Based On Multiple Selections
Hello, I currently have a Smartsheet form that allows users to select multiple options: Each option corresponds to a specific contact name: I need to come up with a formula that auto-populates every contact name in one row based on the choices the user selects on the form. I figured out a way to do so when they only select…
-
Conditionally Parsing Values from a Multi-select Cell
Hi! I am trying to create a column formula that pulls only multi-select values which contain the string "ML" from a multi-select column. Here is example output that I am looking for: In this case, "Templates Used" contains the full list, while "Mini Lesson Templates" should only include values from "Templates Used" which…
-
Adding one working day (no blanks)
Hi, I am trying to add a day onto a date generated from a previous date - However, it needs to be a working day and the cells with no previous date need to stay blank until the previous date is entered... i am currently using - =[Expected Final or QA Approval]@row + 1 - however the cells with no date in the previous cells…
-
Formula Assistance
I am attempting to do the following: If status is Complete or N/A = Green If start date is within 5 days or past due and status is not Complete or N/A = Red If start date is more than 5 days and status is not Complete or N/A = Yellow I have the following formula, but no luck. Any help is greatly appreciated.…
-
How to count how many interviews in the current week?
I am currently trying to track how many interviews are scheduled in the current week per fleet type? The formula I have is counting 7 days from today but I would like to be able to count for the current week. =COUNTIFS([Interview Date]:[Interview Date], @cell = TODAY(7), [Interview Date]:[Interview Date], @cell > TODAY(),…
-
Changing a cell value based on multiple criteria
Hi everyone. I have been attempting this formula all day with no luck. Hopefully someone here can help out. I have a sheet with the following columns: Approved, Approval Need, Sr. Dir Comm Sol Sales Ops Approval, MA Dir. Comm Sol Sales Ops Approval, Reg Sr. Dir Comm Sol Sales Ops Approval, VP Approval The Approved Column…
-
Formula to set the Task Health.
Hi Good Morning, I have a question on this formula. Can you tell me what I did wrong please? Thanks for your great help.
-
If Imported File Contains the Same Value in a Field Multiple Times Automatically Create Children
Okay. This is super hard to explain. Here it goes, I will be importing an excel file to smartsheet through zapier. One header field is called "Reference". I will be importing orders, and how it exports into Excel, each individual product on ONE order will have the same Reference number. For example, 5 rows might say…
-
Get a list of Distinct / Unique values
Hello, Gentlemen! Here is the situation: I need to get a list of distinct/unique values in a column using a formula on Smartsheet. I know how to create this formula on excel, but when i convert to Smartsheet, it simply doesn't work. The formula that I used in Excel is the following: =IFERROR(INDEX($A$2:$A$10, MATCH(0,…
-
Auto Numbering out of sequence when sections copied
Okay, I finally got this working the way I needed. As this project grows I will need to "copy sections" down for additional data. The gray row is for a parent, and the white are the child rows. The column labeled "Auto" uses the Auto number format. But for the life of me, I do not understand WHY I cannot copy down sections…
