-
Determining if all check boxes are checked.
How do you write a function to see if all boxes are checked on a row with multiple checkboxes? I tried using the SUMIF(Check_Box_1@Row = 1) and attempted to use a total number of checks to evaluate, but it does not like that. I tried using IF((checkbox=1 AND Checkbox2=1),"true","false) But that concept did not work either.
-
COIUNTIFS as an OR
Is their a way to use the COUNTIFS as an OR. Currently, it will count all conditions of a cell that match the conditions given. =COUNTIFS([Clothing Item]:[Clothing Item], "Jacket", [In Stock?]:[In Stock?], 1) will give me the count of all "Jackets" that are "In Stock" However, I am looking to count if [Clothing…
-
Sheets have Data Validation functionality?
Do Smartsheet Sheets have Data Validation functionality like Excel? I'm looking to preserve the order-of-operations and to ensure my automation triggers after users fill out 2 drop down cells, a text/number cell, and a checkbox cell. (The automation moves a row to an archive sheet, once the four cells are no longer blank.)…
-
Formula to return a value based on the current month in the SAME sheet
Hi, I'm having trouble getting this formula, I've tried a lot of options and am probably over-thinking it. In the image above, what I want to return is the 5% value. I have a helper row at the top under "12/2024", 5% relates to a value for the month of December. There would be columns in this sheet through 12/2024 and the…
-
Lookup multiple values from a dropdown cell and SUM
Hello, I am trying to populate Total Points from Sheet 1 with a formula. I would need to do a multi-value vlookup for my Sheet1[Color] and grab the related points from Sheet2[Color] and SUM them into my Sheet1[Total Points]. Is there a way to do this in Smartsheet? Please see attached images Thanks in advance
-
Creating and IFERROR/INDEX/MATCH Formula for Exact Match
Greetings! I am seeking assistance to create an IFERROR/INDEX/MATCH formula that will look for an EXACT match of an Account ID between two Smartsheet. In Smartsheet 2 below I have an Iferror/Index/Match formula in the Status column that looks at the Account ID @row, searches the Account ID column in Smartsheet 2 and…
-
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…