-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…
-
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…
-
STOCK FOLLOW UP/ FORMULA/LINKED SHEET
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
Sending Rows Monthly to Individuals w/o Underlying Sheet Access
Hey y'all - I'm looking to set up a sustainable option, probably a workflow, to send row items to an individual for all entries they submitted in the past 30 days, without giving underlying access to the sheet. The specific use case here is this is a team wide hour reporting sheet, and we want to give folks visibility into…
-
Possible bug: Smartsheet adds a trailing space to random cells
I've encountered some strange behavior where Smartsheet automatically adds a trailing space to a cell. Below are two columns. The right column adds a "|" to the value in the left column. You can see that in the penultimate row a trailing space is added to the cell: I am using the COLLECT function to show the contents of a…
-
What would be the best way to turn a YEARDAY value into a regular date?
Hello, In my company, we have a date code we put on our products. This date code consists of a Julian Date (3 digit YEARDAY value), the 2 digit year and then the machine it was produced on. We are reporting this date code into a sheet and I am wondering the best way to convert it. I have thought about using an if statement…
-
Multiple nesting help!
So I have 6 survey questions with response options of "below expectations, meets expectations, and exceeds expectations." I need it to tell me how many below expectations for question 1 are in each region and so forth for each response option and region. So far this formula works great! =COUNTIFS([Delivery…
-
Cannot find new address for a contact from an automation or sheet
We did not want emails to go to external contacts, so "tricked the system" by creating contacts with the same internal email address: eg. Contact 1 : contact1@internalemail1.com Contact 2: contact1@internalemail1.com Recently, smartsheet blocked this approach and does not let us create multiple contacts with the same email…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
