Formulas
Discussion List
-
Formulas and functions in formsIn Formulas and FunctionsHi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the c…Answered - Pending Review 8 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Formula WoesIn Formulas and FunctionsMy old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), {Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19…
-
Checkbox formula with percentageIn Formulas and FunctionsSmartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you! (Image)
-
how to make decimals work?In Using SmartsheetHi i´m having a #UNPEARSABLE error everytime y tried to use decimals in my formula, for example: =IF([KPI ASIGNACIÓN DE OBRA]4 > 3; ([KPI ASIGNACIÓN DE OBRA]4 - 3) * 0.01) how can i multply with decimals? Thanks
-
Imported Formulas from ExcelIn Formulas and FunctionsHappy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it…Answered - Pending Review 12 views 5 comments 0 points Most recent by Cat Werbeck Formulas and Functions
-
Pulling data from a sheetIn Formulas and FunctionsGood Morning, I have a report that I do monthly that records the data from the following sheet. At the end of the month I usually filter columns and manually count errors for each responsible party and move them to a another sheet that rec…
-
Gathering data from 1000 sheetsIn Using SmartsheetHello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to …
-
URL Query string did not move with "Save as New" How to remedy?In Formulas and FunctionsI used a test workspace to create 2 data base sheets. One to hold existing info and one to hold newly created info based on existing. Users create this new data by clicking a URL to get to a form. I created a form and appended a query stri…
-
Formula to count total number of items selected in a column of multi-select fieldsIn Formulas and FunctionsHi, I have a column called Type, which I've set up as a multi-select drop down. I'm struggling with a formula to count all the items that have been selected. For example, they may have selected 4 responses on each row, but when I created…Answered - Pending Review 1 view 1 comment 0 points Most recent by David Tutwiler Formulas and Functions
-
Using If Formula to Populate Status of Parent RowIn Formulas and FunctionsI am looking for help writing a formula to populate a parent row of a Single Select Dropdown column. The Parent row should reflect the Status of the Child rows - for instance, if any of the Child row statuses are set to Not Started, In Pro…Answered - Pending Review 18 views 3 comments 0 points Most recent by Bridgett Alonso Formulas and Functions
