-
Formula help on RYG Balls for Baseline Variance
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. It just turned complete things Green and everything else yellow, because the variance is in Days (eg. 1d or -2d not a read…
-
One template with scroll down options for different timings of tasks
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 types and using different packaging pritnters which has influence on overall project timing for new product introduciton. I…
-
Create "SAVE FORMULAS AS TEXT" Option in Backups, Exports, Snapshots, etc.
My tiny brain says that this feature request would be fairly simple to create, and I know it would make many of us very happy. FEATURE REQUESTED: Create an option to "Save Formulas as Text" when doing a "Backup", "Export", or "Snapshot". If checked, the system would place a special character in front of all cells in the…
-
Referencing a cell from a row based on a formula? MAX/COLLECT or something else?
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 formula to show the DATE PAID field from that same row of the most recent invoice. I cannot simply use the same formula to…
-
How to add the first digit in a cell along a row
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 various columns that contain the responses. Is there a way to do that? Just capture the first digit vs the verbiage so we can…
-
Trying to pull data from one sheet to another
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(COLLECT({Most Recent Vehicles Check in/out Range 4}, {Most Recent Vehicles Check in/out Range 3}, HAS([ASSET#]@row,@row)),"-") I…
-
Linking Parent and Child Rows with a Unique Identifier
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 automated [ROW ID] column to reference. We created a [SLIP ID] column and used =PARENT([ROW ID]@row), and it does populate the…
-
Writing a formula that Sums the values in the "PO Amount" column for a specific company
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. This is the formula I have tried: =SUMIF(AND({In Vivo Study Tracker Range 1},<> "ABC Company", {In Vivo Study Tracker…
-
Formula for SUM IFS
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!
-
INDEX/COLLECT to add Error Statement if no TDL #
Hello, and thanks in advance for your help on my formula. I do not understand why I am getting this error on my formula. I am working on adding my formula to the sheet in the first screenshot. I am referencing the sheet in the second screenshot. The 1 and 2 reference which part is which for the named ranges. I know why I…