I'm curious to see if there is a formula out there that I am missing. Currently this formula takes this current year and subtract one from it and also references a month based on a monthly column. So …
hello all I'm struggling with this because the variance is in Days. I did a basic IF statement where: if the Status = complete then Green, and "nested if" if the Variance was < -5 then Red else Yellow…
Dears, As we know making formulas in duration time is not possible, so I'm looking for other option to make life easy in below scenario: We have several production plants, producing different product …
I'm using this formula in my TASK sheet to find the most recently submitted invoice for each TA from my INVOICES sheet: =MAX(COLLECT({Invoices Range 3}, {Invoices Range 1}, TA@row)) I want to add a fo…
Hello everyone, would love some feedback on this tutorial. I was answering a user's question regarding INDEX and MATCH (thread post here), and thought it would be beneficial to share my example to the…
I used smartsheet to do a survey. We used numerical rankings with a description, (for example: 1 = Not familiar, 10=Very Familiar) as drop down choices in the form. Now, we want to add and average var…
I'm trying to get the most recent submission of a form (about vehicles) to pull the most recent mileage to our master vehicle sheet. I have tried several things, and I can't figure it out. =(JOIN(COLL…
Looking for a way to tie Parents to Children with a numeric value, so if they become separated and lost in a sort, they can be easily found and nested under the correct Parent again. We have an automa…
I am trying to write a formula that calculates the sum of a column on another Smartsheet ("PO Amount") if the value is a number and is not company "ABC" in the column "Vendor" on another sheet as well…
I am looking to write a formula that Sums a PO Amount column if PO is a number and Vendor does not equal ABC Company. Any help would be greatly appreciated!