-
Generating values that can be referenced in a drop-down
Hi, I'm looking to create a formula and cell reference system that can be used to generate a value that can be referenced in another cell or ideally a form. Here's the workflow breakdown. The field fills out a form that creates a new line with an auto-generated "Request Number" If the form has a "Build" in the "Request…
-
Normalized Rank Formula
Hello - I am trying to recreate the formula below in my sheet. However, instead of using tabs in excel (e.g. 'Project Type Weight'!B:B), I am tagging the row and dragging the number of rows down (row1:row100). I am getting either an unparseable or invalid operation error. Can someone please help? 🤣 Excel Formula:…
-
SUMIF Reference another sheet formula
Hello there, i am currently trying to sum the total numbers of case from a date range while referencing another sheet, and keep getting an error and not sure how to proceed. Please help!
-
SUM Cells with COUNTIF Formula returning zero value
I've built a summary table to count the number of "Issues" that meet certain criteria. I'm using a the COUNTIFS formula to do this. This summary sheet feeds a dashboard that I use pie chart on to visually show the breakdown of Issue categories. Piecharts show an error in Smartsheet when they have a zero value to display,…
-
Display results of a column formula on a form or response.
I have a simple form that allows users to answer yes/no questions with a checkbox. On the SS I have a formula column which sums the count of the yes answers and gives a score. I would like the users to see that score on the form either as they fill it out, or once they submit in the confirmation message or in the email…
-
Aligning Text in a cell
Can you help he achieve this format? My sheet has a long columns make it difficult to scroll to see details. So I am creating a column to concatenate values to easily see all values within the row. But I cant align them like below. Do you have any idea how to achieve this? Thanks Expense 1: Expense value 1 Vendor: vendor…
-
Conditional search and return
My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique…
-
COUNTIFS children based on project name
Hi, I am currently trying to extract data to add to dashboards for synthetics, and a requirement is to know how many sub-projects are in any given area. I am after a way to reference my sheet using a lookup function to return the number of children in each project with a certain column (Task name) The formula must look at…
-
basic formula to auto-populate one cell based on selection in another cell
Hello - Hopefully an easy question, I just have a mental block when it comes to the formulas. I have a "Location" column with six options (single select). I have another column, "Representative" that has 4 selections. I would like the Representative column to auto populate based on what is selected in the Location column.…
-
countIF a value column if the attribute is along side another attribute in a "Multi select Column"
Does anybody know if you can create a formula that will count the values in a “dropdown (Multi-Select) column", when adding summary fields on a Smartsheet list? What is happening now is, if I have Apple and Orange in one field and I want a count for Apple. it will not count it. Only if I have Apple along in a field? If I…