-
Multiple Forms to One Sheet
Hello! New to SmartSheet. Was wondering if there is any way to do a "Check-in" with multiple forms. For example, 7 unique forms with separate location/date (hidden values?) with one entry of an employee number. Then the sheet would have one row of data with the first column being the employee number and the second column…
-
Formula to count of items in a multi dropdown list
Hi The drop-down multi select is very nice and useful. I started to use it yesterday, but I need to use the formula =countif(range, criterion). I want to count how many times a value is repeated in a range that has multi values. I use the formula countif and only count one time a repeated value when the cell have multiple…
-
The IF function
I want to be able to type in the field if the Value is False. I can copy the formula to all the field in the column and overtype the formula. but if I convert to a column formula then I cant do this. Any ideas?
-
Trying to reference two sheets but having trouble with second reference
Hello, I created active project and archive project sheets. When a project is completed, it is automatically moved to the archive sheet. I set up a timesheet that references both sheets and looks for the project ID to automatically fill in the three fields for project name, project type, and solution type. It works fine…
-
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…
