-
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…
-
Change symbol color based on specific criteria.
I want to change symbol color based on the below criteria. Red- if Status = "Scheduled" and Days open is equal to or greater than 14 Yellow- if Status = "Scheduled" and Days open is between 9 & 14 Green- if Status = "Scheduled" and Days open is less than 10 Gray-If Status = "Complete" I may not need the "status =…
-
Change Time into Military
Hi all - Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involved - only looking for the time conversion. Yes, we could ask for military time in our…