-
Using INDEX/COLLECT to return multiple values
Looking for the proper way to return multiple values using INDEX/COLLECT. I'm assuming JOIN needs to be in there but can't get it to work! Both without and with JOIN, the formula still produces the first value only. This formula matches a project number from one sheet to another, and is supposed to return ALL of the…
-
Using Countifs to Check for Multiple and Exact Conditions
Greetings! Reaching out to this group for assistance in creating a formula that counts the number of times a certain Product is associated with a given Account ID. The challenge is that the Account IDs may include the same characters but differ based on the case of a letter (a cap or small "a" at the end of the IDs shown…
-
Summary Field return symbol for most recent entry
Hi, I've been searching and testing without much luck. I have a task list that the project health is updated with each task. I added a column for last modified date. I would like to have the summary field reflect the health on the row where the most recent modified date is. This summary field will be collected in a summary…
-
MIn and Collect fuction not returning value
=MIN(COLLECT({RAW NOC INC Data Range 1}, {RAW NOC INC Data Range 5}, "Outage", {RAW NOC INC Data Range 6}, "Mountain States")) I am using the above formula and it is returning a 0 and not the oldest update time. When i change it to date as the format i get nothing but a blank spot. Catch is i want the date and the time…
-
Can a milestone task be closed based on completion of an approval task?
In each of my parent group of tasks I have an approval task, followed by a milestone task. Both are important for reporting. Example: Task1: Manager approves ABC Webpage for publishing Task2: Milestone: ABC Webpage ready for publishing - Predecessor for Task2 is Task1. Problem: When Task1 is marked Complete, I want Task2…
-
Need another pair of eyes - Know there is an easier way
I have 2 sheets (soon to be 3) where I am pulling metrics from 25+ different sheets to get monthly data. It is working, but every month I have to manually edits every row (over 300) to add the next month of data. So I would love some ideas on how to make this easier and less manual. Here is an example of my sheet and…
-
Expression using the "Created Date" field
I am trying to have a column default to a specific dropdown option in a grid/sheet if the "created date" = Today. Is there a way to use this?
-
Identifying Duplicate Values through Conditional Formatting
Smartsheet Community Members - I'm using Smartsheet (Forms) to manage system access requests. Users provide their Username and to which System(s) they need access. I'm trying to employ conditional formatting so I can easily identify which requests are duplicative based on whether a request already exists for the same…
-
Using COUNTIFS with OR function spread across multiple ranges
Hello, I am trying to build a COUNTIF function that will count all cells which meet criteria 1 and either criteria 2 or 3, which are found in different ranges. Example: In Sheet1, I have the following columns: shape, color1, and color2. In Sheet 2, I would like to create a function which counts all observations in Sheet1…
-
Workflow Best Practice in Smartsheet on below scenario
Dear Smart Team, I hope all are doing well. I am having below scenario of workflow with 7 to 8 level of approval. 1) Scenario 1, Type in (A, B, C) This workflow is requires 1 verification and 7 Approval (1,2,3,4,5,6,7) 2) Scenario 2. Type in (D, E, F) This workflow is requires 1 verification and 6 Approval (1,3,4,5,6,7)…
