Formulas and Functions
Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.
Discussion List
-
How i can add a other currency like THB (Thai Baht), Currencys which are not listed?In Formulas and FunctionsHello Community, I would like to add other currency, THB Thai Baht, Currencys which are not listed? Thx in advance S.Carlo
-
Join Function Not Working As ExpectedIn Formulas and FunctionsWhen I join across cells it is taking the last option from the Core Column and the first option in the Calyx Column and combining the text. Any suggestions will be helpful. The formula I am using is =JOIN(Core1:Calyx1, " ") (Imag…
-
Can IF, Contains and VLOOKUP be combined?In Formulas and FunctionsHi all, I am trying to combine IF and CONTAINS with VLOOKUP (refer following) but it is throwing #INCORRECT ARGUMENT =IF(CONTAINS("1", {Count}, VLOOKUP("TD", {Mastersheetrng}, 2))) Can these be combined, or some other c…
-
A Single Formula to SUM a variable range of cells in a rowIn Formulas and FunctionsHi, I am trying to write a formula that will SUM between one and twenty columns in a row, based on the number in another cell in the same row. If the number is 20, I want to sum all 20 cells in the row. If the number is 19, I want to sum …
-
Formula renumbers when row added - I don't want it to.In Formulas and FunctionsI have a formula that populates the Asset # =IF(COUNT(ANCESTORS([Deliverables and Tasks]@row)) = 2, ([email protected]) + 10 + COUNT(DISTINCT([Asset #]$1:[Asset #]6)), PARENT()) This generates MA100, MA101, etc. where each Ancestor = 2 (basical…
-
Formula needed for IF functionIn Formulas and FunctionsI need a formula to say if a certain cell's number is less than 1, then another cell equals 135, and if that same cell's range 1-2, then another cell equals 225, and so on. My ranges are: <1 = $135 1-2 = $225 2-9 = $90 10-19 = $72 20-2…
-
Calculate % on time deliveries for teamIn Formulas and FunctionsHi, I was able to use the following formula to count the % of on-time deliveries per team member. =COUNTIFS([Work Days Between Due date and Date sent]:[Work Days Between Due date and Date sent], <=1, Reviewer:Reviewer, "ABC"…
-
Task DependencyIn Formulas and FunctionsHi Team , As part of Program of Work sheet for a project , i have created a task which is a collection is set of sub tasks that can be completed if only the subtasks has been completed .However ,i am facing this issue where in my end task…
-
Report from 2 sheets shows same column header twice and doesn't combineIn Formulas and FunctionsI have a report of a combination of 2 sheets. Everytihng is the same but they both have one column called "Event Sub-Type" and for whatever reason, the report shows 2 "Event Sub-Type" columns (it doesn't do this with an…
-
How to capture a value from multi-select columnIn Formulas and FunctionsWhich formula works better to find out if a value exists in a multi select dropdown column? I have responses collected from a survey and one of the column was multi-select dropdown list type column. I'm trying to separate out the selection…
