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
-
Index QuestionIn Formulas and FunctionsI have two smartsheets. One contains my budget and one contains budget vs actual. Currently, Im using an index function to find the budget for the month of each cost account BUT every month I have to go update the column index in the funct…
-
Shorten numbers & format to display thousands as "K" , millions as"M" but still remain as numbersIn Formulas and FunctionsHello everyone, Good day. I'd like to ask your help regarding a task I'm trying to complete on Smartsheet. I'm trying to shorten the numbers in a table show thousands with "K" and millions with "M" after the first comma…
-
Cells with a formula date calculation are changing automatically...help!!In Formulas and FunctionsHello all - I'm throwing this out there as it's completely stumped us and I'm hoping this has happened to someone else and they know what's going on! We have a sheet that we have formulas created to calculate a backward scheduled start a…
-
Dashboard - showing tasks/projects for a particular month or productIn Formulas and FunctionsI have sheet which has a column shows upcoming improvements (projects) to products, another multi-select column which states which products are affected, and then another column for the target release month of that improvement. Is it possi…
-
Index Match - Multiple Criteria Referenced From Another SheetIn Formulas and FunctionsI am building an employee lookup sheet. This sheet is referencing a sheet that is populated from an excel spreadsheet that HR runs. They will update this sheet monthly. The sheet has managers, area managers, district managers, AVPs, etc. S…
-
Split a number using LEFT and Right FormulasIn Formulas and FunctionsI have a location number that is 6 digits long. I am trying to create a formula using LEFT and Right to add a dash after the first 4 numbers. EX: if the location number is 123456, I want to create a formula to show 1234-56
-
Help with a week formulaIn Formulas and FunctionsHi, I need assistance in creating a formula in which it tells me what week we are into the month, so every month on the first it must start at week 1 and then every Monday thereafter it needs to go to the next week please? Regards Rainier
-
Here I have data and My task is to apply filterIn Formulas and FunctionsPlease have a look and help me with this, Here I have data and i My task is to apply filter EX: I need data which is < 0.7 (Virat has four allocated categories if i add all of them will get sum as 1.7 ) and dhawan is @ 0.9... i need a f…
-
AVG(COLLECT) issuesIn Formulas and FunctionsThis discussion was created from comments split from: Averageifs Question.
-
Trying to use a IF(AND formulaIn Formulas and FunctionsThis discussion was created from comments split from: If Function between different sheets.