-
How can I create 2 sheets in 1
I am trying to figure out how I can basically put a divider in my spreadsheet so I do not have to keep sliding the slide bar back in forth for the entire screen and just want to do half. For example, i want to be able to keep the first 6 columns on the screen and just slide the remaining columns to the right of the first 6.
-
COUNTIF Formula in Multiple Dropdown Box but Exclude a Word
I’m trying to create a COUNTIF from a multiple drop down column (referencing another sheet). Two words are similar: Active and Inactive. If I use CONTAINS, it counts both Active and Inactive: =COUNTIF({Certified Roster Range 1}, CONTAINS("Active", @cell)) If I use HAS, it counts when Active is the ONLY item listed in the…
-
Verification with Multiple Cells
Hi! I'm not sure this is even a thing, but I'm newish to Smartsheet so figured it couldn't hurt to ask. I pull transaction reports from our accounting system, and need to verify that the person who made the purchase used the correct ID. Here's an example. I need to verify that the name in the Employee Name column matches…
-
If And Formula including dates and isblank
Hello, I am trying to create a formula that will flag the column Delivered Out, if the On Hand Inventory is equal to 0 and the Date Delivered is today or in the past. Both conditions must be met so if On Hand Inventory or Date Delivered Out is blank, it does not flag Delivered Out.
-
Automate Date Fields
I have reoccurring tasks that have start dates and end dates. What I would like to do is after the status changes to completed, then automatically change the date fields to the next occurrence. For example: I have a task that has a start date of 7/1/25 and an end date of 7/10/25, and that task reoccurs quarterly. Is there…
-
Top 10 chart based on most entries
Hi everyone - I'm wanting to create a dynamic top 10 list for a few metrics on a sheet. In summary, we have an issues log. I want to be able to chart the top 10 customers with the most complaints added to the log. As well as the top 10 reasons for the compaints, etc…. Similar to what i would do with a pivot table in excel.…
-
We have tried several IF(INDEX formulas but keep getting error messages.
We are referencing the sheet below with the “BARCODE” and “PIP” column and placing a checkmark on a separate collection sheet. We have tried several IF(INDEX formulas but keep getting error messages. What we would like to do is check a box on a separate sheet if the PIP is “Red” or keep the box unchecked if the cell in the…
-
=IF(AND(OR(HAS Column Formula with 3 results (option 1, option 2, both) #INCORRECT ARGUMENT SET
I have a search range which is a column that has up to 35 bus routes. The bus routes are operated out of one of two facilities, "ARCADIA" and "POMONA". I am trying to create a column formula that will return a result of "ARCADIA", "POMONA", or "BOTH". I can successfully create a column formula that will return one of those…
-
Edit in report
What do i need to do to make the fields in a report be able to have information added, edited, removed, etc. when the report is open
-
Is Formula correct?
I am using the formula below to count the number of rows where the "Rounding Tracker Range 2" column equals 1 and the "Rounding Tracker Range 4" column equals "Cindy". But it returns #unparseable. What am I doing incorrectly? =COUNTIFS([Rounding Tracker Range 2]:[Rounding Tracker Range 2], 1, [Rounding Tracker Range…