Formulas
Discussion List
- 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 na…
- 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 …
- 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 ter…
- 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 sum…
- 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…
- Looking For a change Order Template that is fill in and can add photos or media
- 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 …- 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 toda…
- I'm trying to retrieve the latest created date and compare it to the date-time. I was expecting to get a date, not a date-time, and that would be OK. =MAX(Created:Created) returns 11/29/16, which is w…
