-
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…
-
Formula Bar Blocking Boxes
I'm sure this is an easy one, but when I'm adding a bunch of math in a specific field, it eventually blocks the entire row. I then can't choose boxes within the row that will be nested in the equation. Any way to hide the formula or make it so I can still see/click the boxes behind it? Thanks!
-
Looking For a change Order Template that is fill in and can add photos or media
Looking For a change Order Template that is fill in and can add photos or media
-
Date Formula
I am having trouble converting this excel formula =TEXT(C7,"mmm-yyyy") to the Smart sheets equivalent. Can someone help me?
-
is there a way to make children auto-calculate percent complete based on start/end date and the curr
I'm new to this program but not scheduling in general. Is there a way to get each child beneath a parent to calculate % complete automatically, based on the entered start/finish dates and the current date? I'm building construction schedules, and don't want to have to manually update huge amounts of child rows, especially…
-
Static Date/Time Time Stamp formula
I am looking for a way to create a static date/time when a specific action is completed in a cell. Currently we created the formula below, but we need it to return a specific static date not just todays date, which changes every day. =IF(AND([Manager Approval]3 = 1, [Internal Processing Status]3 = "SERVICE COMPLETE"),…