-
Is it possible to hide a row based on checkbox status?
Hi, We have some scheduling sheets with a set of tasks (deliverables) for each project. Each task has a checkbox to tell the team whether that deliverable is required for that project. If the checkbox is empty, cells in the row are filled with N/A and conditional formatting is applied. So the checkbox has both a formula…
-
I have messed up one of my formulas and don't know how to fix it.
I have accidentally deleted one of my formulas and can't get it working again. Please help. I need to do a vlookup but I keep getting a no match error =VLOOKUP(Project1, {Project Ref Number}, 1, false) this is my formula, not sure what the problem is, unless there is something with the reference table. What I am doing is…
-
How to get all rows with 1st column starting with specific alphabets
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 columns A, C, and D if the column A starts with 'as'. Please help me to achieve this. Thanks!
-
Formula Auto-Fill not working
Hi, Conditions That Trigger Formula Autofill You’ll see formulas populate automatically when you type in a newly inserted or blank row that is: Directly between two others that contain the same formula in adjacent cells. In my example below, I inserted a row between (in white) between rows who contains the same formula but…
-
Helper Column Formula
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 [Order Required] column as it already has a =IF(OR(ISTEXT([Quantity Required]@row), ISTEXT(Unit@row)), 1, 0) formula in it.…
-
Using values returned by formulas in other formulas
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 summarise these ratings per theme, focus area, assessment, etc. I obviously need to make use of the 1,2,3,4,5 values in the…
-
Dynamic reference to the cells
Hi, I have one Smart-sheet A with all the details. One of the column is Date. I created an another Smart sheet B where I have all the formulas. On of the formula I am using is =ROUNDUP(MONTH({QMS GAP Analysis Range 9}, 2)) As each cell in the Smart-sheet A has different dates. I can't drag the formula in the Smart-sheet B…
-
Formulas in sheets with auto-number columns
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 them. How do I add those formulas without adding them in the first row which triggers the automatic numbering? I thought of…
-
Flag Formula
Hello I would like to make the flag red if 2 criteria are met % Column is under 80% AND Deadline is within the next 2 days? IF(AND(% Column)@row), <80%, (Deadline)? I'm stuck on the second half of the formula can anyone help? Many thanks
-
Creating automations and the dropdown list for contacts is incorrect
I have email addresses that are wrong in the automation. My contact list is defined and only is accepting the prescribed values. I would like to remove the ones from the automation if possible so folks don't inadvertently select the wrong contact. Anyone else come across this?