-
Nested "if" formula
I'm trying to convert this excel formula to Smartsheet but can't find the right procedure. Keeps coming back as unparseable. =IF(J3=100%,G3,IF(J3<100,"")) J3 will always be filled in with a % and G3 is a dollar amount. Any help is appreciated. Craig
-
IF/AND/BLANK Formula Logic
I'm trying to write a formula to reflect a progress % (using the bar symbol) based on three fields, where one field, if filled in, counts as 25%, the second field, if filled in, counts as 25%, and the third field, if filled in, counts as 50% (to equate to 100%). I'm using =IF(AND(NOT(ISBLANK, but I'm receiving errors. I…
-
Automatically Create Parent Row From Child/Children
What will be imported is the white (2,3 & 5,6,7) rows. I want a parent (ex: orange rows 1&4) to be auto-created for any unique number in the "Reference" field. Any help would be appreciated! Thank you!
-
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.
