-
Long Decimals - 7 digit decimals
Good morning, I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating the last 2 digits when I leave the cell. Losing the last 2 digits changes the number and messes…
-
Combine a column from two different sheets ="Complete"
I am attempting to take info from a column from two different sheets and combine the total. The formula I am working with to perform this for a single column is: =COUNTIF({Project Plan - Project A Range 1},="Complete") I tried using the following: =COUNTIFS({Project Plan - Project A Range 1}, ="Complete", {Project Plan -…
-
"SUMIFS" with "AND" and "@cell" combination returning wrong value
Where [Begin]@row = DATE(2020, 7, 1) and [End]@row = DATE(2020, 7, 31) The following formula returns returns incorrect value: =SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= [Begin]@row, @cell <= [End]@row)) But, the following formula returns correct value: =SUMIFS({Maint-MLR-LaborHours},…
-
How do I reference the contents of a specific cell in a different sheet in the sheet summary?
Hello, Basically, I am trying to write a formula in the Sheet Summary of a sheet that shows the contents of another cell on a different sheet. I am able to write a within sheet cell reference for example, =[Latest Update]77. However, I want to change that formula to reference a specific cell from a different sheet. I've…
-
How to get an average of multiple symbols (harvey balls) on a single row?
Hi, I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that correlate to each category. I have the columns next to each so I can use the "range"…
-
Summary Sheet
Hi when i run a summary sheet, if the sheet uses drop down cells it does not pickup all the items I want to count. for example if i have Internet Access and TV Systems in same cell it does not count the Internet access when i try to do a counitIF. it only counts the cells where i have "Internet Access" only in the cell. i…
-
Find most recent updated status for category
Hi all, I'm searching for a solution on following idea: I have a sheet with following four columns: Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls) Now I want to auto-populate "Previous Status" with the last "Current Status" of the same "Category" when a new row is entered.…
-
Updating a cell based on checkbox column and a multi-select column
Hi there, I am new to SmartSheets and am struggling to use the CONTAINS formula. I need to allow for the option for [Trial Type] to be either Sales Strip, Sales Demo, or both Sales Strip and Sales Demo The formula below doesn't work if both Sales Strip and Sales Demo are selected. Do I need to use the CONTAINS function? Or…
-
How do I get the % to stay at 100% and not 150%?
How can I get the Completion Rate to only show 100% rather than 150%?
-
Multiplying Cells in an IF statement
Morning Smartsheeters.. Was hoping someone could shed some light on why this statement isn't working.. =IF(Part75 = "Labour", [Supply Price]75 * [Quantity]75) I'm trying to multiply two cells based on whether the labour cost is Labour, or Labour O/T.. but I'm getting an INVALID OPERATION FAILURE. Thank you.
