-
Populate Status Based on Children
I need a formula that will auto populate the status of a parent task based on its children's statuses. If all children have the status "Not Started", the parent should reflect "Not Started". If any children have the status "In Progress", the parent should reflect "In Progress". If all children have the status "Complete",…
-
Summary Sheet Formula - Count 2 Selections from a drop-down in the same Column
Hi, I am trying to count both "YES READY" and "YES READY NO SHIELDS DUE TO CREDIT HOLDS" in a Summary Formula. This is a drop-down in a column and I am trying to include both in a summary formula.
-
How Generate Quotes Via Smartsheet
I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini excel sheet per row. the output would be a price but if needed the breakdown is seen. I would like the the Quote numbering…
-
Date Completed triggers Check Box
I want my user to enter the Completed date and the Check box in the Completed column gets checked. I know this is simple, and I have found answers for the other way, but I want it set this way.
-
Text to different Rows - Split by delimiter.
Hi, I have a cell@row value in the column Zone1 separated by a delimiter which needs to be split into different rows as a list of values similar to column Zone1new. Could i get help on this?
-
IFERROR and OR
I have these two formulas in different columns: =IFERROR(INDEX({Frame ECN Updates Range 2}, MATCH([ECN / PLR / FF / CEG]@row, {Frame ECN Updates Range 1}, 0)), "") =(IFERROR(INDEX({Frame Feedback Updates Range 1}, MATCH([ECN / PLR / FF / CEG]@row, {Frame Feedback Updates Range 3}, 0)), "")) Individually, they each output…
-
Index Match Help
Hi! any help on why this formula is not working? =INDEX({Operations BOB LON H}, MATCH({Operations BOB Range 4}@row, {Operations BOB Project Code}, 0)) this is a similar formula that we have and it is working: =INDEX({Ref. BOB Range 1}, MATCH([Project Code]@row, {Ref Project Code}, 0)) they appear the same to me, what am I…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
I need some help with custom rounding in decimals
Hi all, I am trying to find a way to use custom rounding within a formula. I've tried using the AI formula generator, but it ignores that part of my request. I have also searched for help online but no luck. Essentially I want to create the following custom rounding based on the outcome of a formula - Between 0.01 and 0.24…
-
Absolute Reference changes if cell is moved
Hi, Looking for help with Absolute references in cell formulas. I need the formula reference to remain the same even if the user moves or copies the cells to a different column. The scenario is Column8 has the formula =SUM([Column 6]@row, [Column 7]@row) If a user moves the Column6 cell to Column9 , the reference in the…
