-
If(And( Greater Than Less Than)
I am having trouble with the following formula: =IF(AND(Percent1 > 0, Percent1 < 6), "Scope", IF(AND(Percent1 > 5, Percent1 < 11), "AE Selection", IF(AND(Percent1 > 10, Percent1 < 21), "Design", IF(AND(Percent1 > 20, Percent1 < 26), "Bid", IF(AND(Percent1 > 25, Percent1 < 96), "Construction", IF(AND(Percent1 > 95, Percent1…
-
Datamesh to Update Engagement Progress for Coaches and Clients
I run a smartsheet for tracking coach/client engagements. There are typically 6 or more sessions in an engagement. Neither coaches nor clients can have access to the sheet. I need the coaches to report the dates of each session in the engagements. Due to the nature of this environment, coaches can report any number of…
-
#Circular Reference when automating Yes,Hold,No decisions
Hi, Hit a lil road block here. Trying to automate the symbols for my status column based on drop down lists, but i keep getting a circular reference when putting in this formula, =IF([Lead Result]1="Win",Status1="Yes",IF([Lead Result]1,="Negotiating",Status1="Hold",Status1="No")) Posting a screenshot of my sheet for…
-
Autofill Date Column with Conditional Formatting
Hi there, I am trying to set up an approval sheet. I would like my "Due Date Column" to auto fill a date 3 days before the date in my "Date" column only if my "Completed" check box is NOT completed. Can anyone help me with this formula? Thank you
-
Formulas: Countif / And / Children Rows
H E L P! What is a simple way to formulate the "Evaluation" Chart in the Screen Shots attached, based off ONLY the children rows of the 4 Departments on the top of the sheet in both the "status" and "risk level" columns? I'm trying to avoid a "messy" formula but I'm receiving an error through all my attempts.
-
Formula DATE & IF
Hi, I have a sheet that I use for accounts. I have a column for Invoice Date, a column for Due Date and a column for Status. I would like a formula for the status column to read "due in X days" ( a countdown of sorts) if invoice and due date same, read "Today" and once the due date is in the past, I would like the status…
-
If "x", and checked box y
Hello, I am trying to Check box = If column 1 ="x" and if column 2 is checked = column 3 to be checked e.g. If Column 1 contains "Street Lighting" & Quote Successful Column is checked, Street Lighting successful box is checked I've tried the following equasions =IF(AND(Team7 = "Street Lighting", (NOT(ISBLANK([Quote…
-
Counting Check Boxes
I'm trying to get a formula to count the number of Check Boxes that are checked in all the Children rows under a Parent row. When using ="Count:" + COUNTIF(CHILDREN(), 1), which is one of the formula examples I'll get this Count: 2 All I'm looking for is the number so I tried =COUNTIF(CHILDREN(), 1) but it doesn't work.…
-
Hiding completed rows and showing all rows easily
I have several sheets with rows that are "old" (completed, sold,...) and that I want to hide most of the time. Conditional formating does that well. But I need sometimes to see them all. How to achieve this easily?
-
Linking Cells from Columns to Rows / Transpose Paste Special
I am trying to copy data from a source sheet to a destination sheet. The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet. I have tried to link several cells at a time, but it only links one cell - not the group of cells. So... I tried to bring in over as column to column and…