-
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…
-
How do I write this formula?
I want to write a formula that calculates the number of days we have from today until we run out of stock. I have: The number of Laptops Available The Avg Monthly Hires and I know we give out laptops at NEO every other Monday (Next one in February 17, then March 3rd, March 17th so on) How can we tell the number of days…
-
Rank Vendors Based on Total Spend
Hello Community, I'm looking for formula that will rank the 'Offsetting Acct Names" by 'Supplier Total Spend'. As you can see below, I captured the total spend per supplier but need to rank these and report on the Top 10. Any assistance would be greatly appreciated!
-
Extract Text and Number in Varying position
I need to extract text and a number to provide me with my account number. In the screenshot below shows an example of the data I am faced with. The formula will go on this sheet shown. As you can see, sometimes there is no TDL #. Sometimes the TDL # is in the front, other times in the middle, and apparently at the end…
-
Auto increment count on Column based on values appearing in another column
Hello, I am trying to add a formula to Column SSI Ref that will count and increment based on the number of times a number appears on SSI# column. I have completed the SSI Ref column for reference as to what I would like to see. Thank you
-
Update one sheet based on two columns from another sheet
Hello I have a request sheet and a review sheet. The request sheet generates a task number after submission of a new row. That task number will be manually inputted into another sheet. Once a review is done of the request, the user hits review complete. I want that checkbox (once its clicked on the review sheet) to get…