I am looking to create a count formula that counts only the Children and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This …
I would like to be able to append/adjust actively sorted values in a range. In other words to be able to handle data more like matrix formulas in excel. Currently this is done with collect, but there …
hi, I have a work approval request flow that being used to our department for document approval process. We have one manager who accidentally deleted the approval request email and we don't know how t…
I have a stock sheet. Rows are the stock items. I have 10 columns that represent orders coming in. i have a due date at the top of each column (treated as text) with the quantity of each the items bel…
Dataset: Required Output: I am trying to extract data from the rows which have its first column starting with particular contents. As I have shown in the attached example, I wish to get data of column…
I have a form where I have logic built in, and if the yes, the next group of questions pops up. There are 10 of these potentials to expand/ pop up, and on the main screen it shows all of the dividers.…
Hi, I want to use a helper column to uncheck a Checkbox column if a certain condition is met. i.e. If [Order Date] contains a date then [Order Required] is unchecked. I can't put the formula into the …
Hi, I have a user populated field (using a dropdown) where the options range from “1-Innocence” to “5-Excellence” – this makes more sense to a user than simply having a 1-5 available for selection. To…
Hello, I currently have a smart-sheet that gathers data from multiple vendors (each vendor has a form). One of the columns is an ID which would be entered through a drop-down. The functionality we are…
I have a sheet with an automatic numbering column. Data for this sheet will be captured through a webform. I need certain columns, which will not be populated throught the webform, to have formulas in…
