-
Equation to populate new number
Hello. I have a sheet with 4 columns: one is the name of the material (Material Name), the next is the quantity of that material that we have in stock (Quantity), the next one is who claimed this material (Claimed By), and then the last column is how much quantity that person claimed (Quantity Claimed). So for example, if…
-
Dropdown box Data in formula
Hello all, and thank you in advance for any help that you can provide. I am using a dropdown box, single selection, to select a date that determines data pulled from a table. I have 10 data values for each date in the table. I am attempting to use VLOOKUP to collect the data with the date from the dropdown box as the…
-
Countif Formula based on Column
I am looking to find a formula that will count if it is a quarter column. My sheet has columns - Fiscal Year, Quarter 2/3 (etc.) and then Monthly breakdowns. FY1 Total | Q1 Total | Jan | Feb | Mar | Q2 Total | Apr | May ... And continues on for a couple of FY. I want to get a count of how many quarters have a value in it.…
-
Using the average and standard dev formula
I am trying to use an average formula to get the average of data from the past 30 days. I tried using collect but seem not to be working as it gives me an error. I also am using standard dev formula both for the past 30 days/data before that row. Please help.
-
Workflow for Tracking Inventory Counts and Bin Locations
Hi, I am trying to setup a sheet to keep track of when we count bin locations in our warehouse and how often. I would like every bin to be counted at least once ever 12 weeks. In our bin locations column, I have a multi-checkbox setup with all 403 of our bin locations in it. We typically count 5-12 bins a day. Can I setup…
-
Sharing to organization
Hello! I was wondering, is it possible to share a Smartsheet Report to everyone in the organization for editing? I'm using the 'Current User' Report parameter to limit what the user is looking at and what can be edited. But updating User Groups when people leave the organization or new users are hired has become very time…
-
Calculated Status Indicator using task duration
Hi, I need to convert a formula that I used in MS Project (see below) to calculate task health status that uses the task duration. Has anyone created a similar formula that they could share? Purpose: Highlight tasks that are running late, based on the actual % complete compared to the “expected completion” using the task…
-
Countif and HAS for multiselect for Quiz answers
I am using Countif and HAS to count a cell if a person has selected the correct quiz answers in a multiselect field. =COUNTIF([Q2]@row, HAS("a", "b", "c", "e")) This is returning 0 and I am not sure why?
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
Way to automate check boxes in a form?
Hello, I have a form with multiple check boxes for people to check off based on which option they want (they can select multiple or just one). I want to be able to have an ALL OF THE ABOVE option but want to find a way so that when a user of the form checks ALL OF THE ABOVE, it will automatically generate all the other…
