-
Using COUNTIF and CONTAINS
I need to count the number of times a word is found in a cell. My constraint is that the cell can contain multiple words (from a dropdown) and I'm not sure the formula to use. COUNTIF works just fine if the cell only contains one word. I see a report that used both COUNTIFS and CONTAINS but I can't get it to work. The…
-
How can i compare dates from different sheets and return 1 and 0 as output.
Hello everyone, I have two sheets: one is the main sheet containing almost 130 columns, all related to project updates, and the other sheet has 7 columns. Both sheets include an ID column and project name. On the second sheet, there's a date column filled with dates. Firstly, I want to check if the ID on the second sheet…
-
Form URL - Manipulate Header/Help Text
I know that we can use formulas to generate URLs that will allow us to auto-fill certain fields within the form using row data. I also know that we can use this to automatically check the box to request a copy of the form submission and that we can use this method to auto-fill the person's email address. What I would love…
-
Averaging A Multi-Select Dropdown for a Value
Hello, I would appreciate some help with a formula. I'm still new to Smartsheet and don't understand how to make use of some advanced functions yet. I have two sheets that I am working across; The first has detailed information on items, but the only two pieces relevant for this are a score given to each item, and the…
-
Why do I get #invalid value?
Hi everyone! I am using this formula in the Date column to pull a date if 2 criteria are met (name of the client and the specific module): =INDEX({Date}, MATCH([Column11]3, {Client}, 0), MATCH([Column4]@row, {Module}, 0)) It works in the "Module 1" row, but not below, any idea why? Thanks!
-
COUNTIFS function with multiple criteria
Hello! I've been having trouble with getting this formula correct. Here are the details. I want to count row A when "service expansion" is present only if row B has "qualifying" or "proposal" or "Negotiation" listed. I've tried several variations but can't seem to get this one!
-
Use a QR Code to start an Update Request?
So I thought I was close with a solution to manage our fleet of vehicles. I created a sheet and used workflow generated update requests to get daily check in information from the assignee of a vehicle. Further, I used other workflows to change the status of the vehicle based on the check in. Also, included milage and…
-
Create a due date
Is it possible to create a due date for the first Thursday of the next month? For example, I want to take a "date completed" and create a due date for the 3rd Thursday of the next month.
-
NEW TO SMARTSHEETS!! Needing advice on creating a formula for N/A answers not to count
Two different equations are being used. Equation 1: =IFERROR((SUM([RN Section 1 Score]@row, [RN Section 2 Score]@row, [RN Section 3 Score]@row, [RN Section 4 Score]@row)) / SUM(IF([RN Section 1 Score]@row = "-", 0, 0.3), IF([RN Section 2 Score]@row = "-", 0, 0.3), IF([RN Section 3 Score]@row = "-", 0, 0.2), IF([RN Section…
-
Formula to list all projects that asked for additional funding and count number of times
All, I want to do the following, if it is possible, for metrics that I need to include on my Smartsheet dashboard. I have tried variations of =COUNT(DISTINCT(COLLECT without success. Here is what I want to do: In a metrics sheet, I want to go to my "2023 IAP Tracker ELT Approvals" sheet, then automatically list all of the…