Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
Two new PPM Functions: Successors and isCritical, available now!In Formulas and FunctionsHi Community, We’re excited to announce the launch of two new PPM formula functions available now in Smartsheet: Successors and isCritical. The Successors function (type: numeric) allows users to calculate the direct successors of a task…
-
Exporting a comma separated set of numbers in a cell to an indepedent set of columnsIn Formulas and FunctionsHi All, I have something like this in a column QCEVCODE: 1,3,2,5,1 for let's say 1000 rows, each one of them is the amount of issues for a type of dataset. I need to be able to export this to independent columns (or any other way to happen…
-
#Invalid Ref error in a report, but not the sourceIn Formulas and FunctionsI'm seeing an invalid reference error in a report on a dashboard, but the source data is good and the vlookup is pulling in the data I want to see. Any thoughts on the cause/solution? I've narrowed down, deleted and re-created the cross…
-
Auto-assign task to next person on Contact listIn Formulas and FunctionsI need to auto-assign tasks in a round robin style (i.e. the assignment goes to the next person 'in line' in the contact list). Is there a way to do this with a formula? I understand that tasks can be auto-assigned based on criteria in a s…
-
Stacked Bar Chart using Metrics and multiple data setsIn Formulas and FunctionsHello, I am struggling to gather data together from multiple data sets to represent as a stacked bar chart. I have large spreadsheets that use dropdown options for data I need such as customer journey and impact rating (high, medium, low) …
-
WeekNumber & WeekDay errorIn Formulas and FunctionsCan anyone help with a way round the weeknum formula that starts on a Monday rather than a Sunday? I'm using the WeekNumber formula to get a current week in conjunction with the WeekDay formula to create a list of tasks due in a current we…
-
trying to add a field to a logic flowIn Formulas and FunctionsHello, I have created a field "New Country". I want to use this in a logic flow "Country where work is being performed". The logic: If "other", then enter New Country. However, they system is not even sho…
-
Basic checkbox counting to apply status option to Parent rows onlyIn Formulas and FunctionsI am unable to get the output to say "Not Started" in the Status column for the formula I am using. What is missing? Also, is there a way to reference "Done" part of the Children of the parent without specifying the exa…
-
Formulae helpIn Formulas and FunctionsHi Team, Can you please suggest on how do I write a formulae that can capture the All Client names separated by "," which are against Red status. The caveat is that the status can get updated periodically and hence today there ma…
-
Hello, I need some assistance with a forumlaIn Formulas and FunctionsI"m trying to set the status in a field to display blank "" if the Start date has not been reached. I'm using the following formula: = IF([Start Date]@row < TODAY(), "") I think this should work, but it is not. …
-
What's wrong with this formula?In Formulas and Functions=COUNTIFS({Sheet - Sales Pipeline Range 1}, [email protected], {OD&I Pipeline tracker Range , "Pipeline")) It just reads UNPARSEBLE. Thanks Phil