-
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…
-
Formula Suggestion: [Column Name]@ to Imply "[Column Name] in This Row"
I would like to offer an idea to the Community to see if this has any support. There are plenty of examples of complaints throughout the community of sheets with complex formulas dogging down the sheet during saves. This can be exacerbated greatly by trying to move rows around the sheet, and the thousands of cell row…
-
How to automate RYG balls using two different column values.
I am attempting to automate the RYG balls using two different columns, the End Date and % Complete columns. The logic is as follows: 1. If the end date is greater than today, the RYG ball = Green IF([End date]2 > TODAY(), "Green" 2. If the % complete is greater than .99, the RYG ball = Green IF([% Complete]2 > .99, "Green"…
-
Setting Conditional Formatting/Formulae(?) for Red Yellow Green balls based on % Completed
Hello, I am trying to have the Red, Yellow, and Green status balls automatically change/update based on the percent completion of each row task. When I click on the conditional formatting button in navigation pane and make new rule of, "If % Complete is between range of 1% and 99%, then change the status column to Yellow"…
-
Formula error in Nested IF Loop
Hi SS Community, Trying to automate shipment status using 'date needed by' and 'expected delivery date', but currently have an error with nested if loop #INCORRECT ARGUMENT SET, =IF([Date Needed by]1 < [Expected Delivery Date (Purchasing Agent)]1, "LATE", IF([Date Needed by]1 >= [Expected Delivery Date (Purchasing…
-
Contract Managment
Has anyone created a smartsheet to manage contracts?, specifically to perform the below activities: * track total amount vs. payments * track payments against deliverable complete * track contract term * track contract amendments : to extend the period, increase the budget, adjust terms of reference, etc. * Track invoices…
-
Subtotals without parent/children rows?
Hello, I'm working on a sheet where rows are continuously inserted using a web form so I can't use parent/child functionality. These rows contain hours spent on clients and sub-clients. I have two summary rows at the top of the sheet and I'd like the hours column on those two rows to have the total hours for clients (row…
