-
Formulas =SUMIF
Hi, I need help to solve this puzzle. I'm using this sumif formula =SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value}) to sum up the total value of invoices against a particular order number. I've checked that all columns are formatted as text. See snap shot of actual…
-
Formula to count cells in a column if box is checked
I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box. In other words, there are two columns to include in the count from my Communication Tracker sheet: Done -- checkbox column and Department -- dropdown column with…
-
Getting information from the latest line entry based on date
Hi, I'm setting up a page where you enter 5S audit test data from a Form. It puts a new row in every time with the 5 different 5S scores each in it's own column. We need to find a way to pull the data from the most recent new row. I need a way of identifying the row with the most recent date and then moving across X many…
-
Select a user defined value for a default in a form
Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table, (box number), then have…
-
Do not want Cells with "N/A" figured in my formula
=SUM(CHILDREN()) / (COUNT(CHILDREN()) + COUNTIF(CHILDREN(), "")) I am using the above formula for percent complete in my project plan as seen by my picture. My question is when certain parts of the project have not been started yet how do you exclude the cell with the "N/A" value in it from being calculated?
-
Force choice between columns
I tried searching the boards, but not sure that I'm asking the question the right way. Essentially, I'm looking to know the following: Within the Smartsheet worksheet, I have two columns both set up in a checkbox format. I'd like to restrict my users from checking both accidentally as it should be an either/or scenario.…
-
Countifs with dates
Hi I'm trying to count a criteria from one column if the date in another column is between two dates (or of a certain month). I've tried the following but formulae is not my strong point so I'm not sure what I'm doing wrong.... =COUNTIFS(Created:Created, >= DATE(2020, 1, 1)), <= DATE(2020, 1, 31), [Content type]:[Content…
-
Centrally Manage Drop Down Lists for Multiple Sheets
I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have to edit drop-down lists manually sheet-by-sheet. I've searched the community for ways…
-
Difference between dates
Hello I am looking to pull some data from a quote log we have made up. What I need to know is what quotes were late submitting by 1-2 days and which were late submitting by 2+ days, so two data points. Attached is a screenshot of the columns we have. Requested due date is when our customer expected the quote and the date…
-
Putting a formula in with a form submission.
We are trying to set up a form where you enter scores base on criteria that populates a form. Based on that data each new line of data from the form needs to have the average score of those 6 criterias. However we can't pre-fill each row with the Average formula we want as the form always drops the data in the row below…
