-
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…
-
Workaround for Voting
Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have a link to a dashboard where they could look at requests that have already been…
-
I need help with At Risk Formula
I am trying to have the at risk flag appear when the following conditions apply: Status is : Comment Resolution, Not Started, Draft, NVX Review/ Comments Due Date is less than 10 days away I was playing around and got this far but its not working =IF(OR(Status@row <> "Not Started", Status@row <> "Draft", Status@row <> "NVX…
-
What formula(s) do I use to reference a Multi-select column in another sheet?
Normally I use Index(Match()) to pull in the value from one row into another sheet. That doesn't appear to work when the source is a multi-select column. I've tried Index(Collect()) but can't seem to get the syntax right. Any help would be greatly appreciated.
-
Formula to return 30,60, or 90 if Date is within 30,60,90 days
Hello, I need a formula to return a value of 30, 60, or 90 if the due date is within 30,60,90 days of a due date. I am going to use this column to group a report to show each bucket of items due in the time frame. I can get the formula to return the correct value if the date is within 30 days, but am not able to nest IF…
-
HAS Formula Returning Wrong Results
Hey Community, I've created a formula to count, collect, and return results based on some criteria. I have also created a report that gives me what I'm looking for. At the report level the results come back correctly, but in my formula to just get a count. It does not. =COUNT(COLLECT({Intensity}, {TargetDate1}, >-30,…
-
Use Max function to return person's name?
Hi I want to use a formula that will return the highest value in column 2 is there a way to do this please
-
Issue with simple division formula
I have a sheet that pulls labor hours via cell linking. I want the neighboring cell to result in total hours / 4, but I am continually getting an #INVALID OPERATION error. In the below, I want CM App Hrs = 40. If I manually type 160 in CM Hrs, the formula works fine. All cells are Text/Number type (including the original…
-
COUNTIFS with greater than or equal to and less than or equal to date range
Hi, I'm trying to run a COUNTIFS on a Smartsheet that has a "Created Date" when a user submits a form. I want to count the number of submissions within a given timeframe, i.e., the month of January. I've tried the following formula: =COUNTIFS({In-Flight IFM Page Request - Created Date}, >=DATE(2022, 1, 1), {In-Flight IFM…
-
Hi - function to remove a flag with a checkbox
Hi All I am sure this will be simple for someone, however I can't find the right solution. I have a flag column which has the following formula to calculate and is very simple and works perfectly: =IF([Activity Start Date]@row <= TODAY(), 1, 0) However I would like this flag then to be cleared if one/or other of two…