-
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…
-
Health of Task or Project using % Complete & Finish Date - Sanity Check
I found something close to what I am looking for here: NEED HELP: Health Formula based on start date, end date, and %100 complete needed. — Smartsheet Community This formula doe s a great job of flagging the dates in relation to time left. However, I am looking for a health check that can take into account both percentage…
-
If then formula with different sheets
Hello, I am looking to create a formula that looks at the Tag Name/ID from these two different sheets. If they are the same, I want the Date Received in Full to show up in the Received by Van Ert column for that Tag Name. For example: The Tag ID in line one on the first sheet is 410-AE-1391B. The Tag Name in line 581 on…
-
Countifs for a range based on checked box in a different column
I am working on a training matrix where our team tracks the operator's training status for multiple assays. We also have a columns for different suites of trainings needed per job title where if the assay is needed for the job title, the box is checked. The ultimate request is to show % Complete Trained based on the…