-
Not sure which formula I need...
I am trying to pull data from the ISIR Pull 2023-2024 sheet and make it populate the information into another range on another sheet. I want the ISIR Pull 2023-2024 sheet to match the Student ID to the Jones Scholarship sheet and pull in the FA23 HRS without having to hand-type it. (Work smarter, not harder, right?) The…
-
How do I prevent the cell I am highlighting from auto-deleting the text in the cell?
I keep running into an issue with my sheet where if a cell is clicked on and I do not click off it or click another cell it will just delete out the text in the cell. This happens constantly where the cell it highlights as soon as I open the sheet will just go blank. If I don't notice it and hit undo the information in…
-
Help with Supply Inventory & Checkout Tracker
I made an inventory tracker to keep track of our supplies, and on a separate sheet I made a tracker for requests to check-out supplies and a form for this. I want people to be able to select multiple items on the form. The issue I am running into is that I had created a formula to pull the number we have “In Stock” from…
-
AND/OR Function for COUNTIF Referencing another sheet
Hello, Smartsheets Gurus! I am building a formula to reference another sheet {ISIR Pulls 2023-2024, Column EX Major (Range)} with two different EX Majors within the range I'm trying to total up. The two things I am looking to identify are EX Major "BSC" and "BSD". If I just do: =COUNTIF({ISIR Pulls 2023-2024 Range 1},…
-
All data gone - help
Main file - Nestle Master file FY24 , i created workflow when checkbox "completed" is triggered that row will be moved to Nestle Master file - COMPLETED. When i start checkinoff boxes for "completed" My whole Master file was completely erased. When i checked activity log it says rows are moved with automatization but even…
-
Broken SUMIF Formula - Sum of column based on info in another column
Hello everyone! I am currently attempting a SUMIF equation that initially worked and is now broken. Here are the parameters. I would like the sum of the dollar amount in this column "FY24 Adopted Budget" to show in a cell in this column, "July Expenditure" based on the information in these columns "Cost Center" (Dropdown…
-
Collect most recent date from another sheet based on certain criteria
Hello I have a fleet maintenance log that has invoices per vehicle with a column that is a drop-down with multiple values based on the service provided. I am trying to make a sheet that would be a quick reference to see the most recent service per vehicle per category. Being multiple services will but under a category I…
-
INDEX MATCH is matching same values to everything
Good morning all, I'm having some issues with this INDEX MATCH, that are really stumping me. Here is my formula: =INDEX({NE INVOICES Range 4}, MATCH([PO#]@row, {NE INVOICES Range 1})) And here is what I'm getting: This would normally be fine, as those PO's don't exist on my source (Here is the source sheet) The issue is as…
-
Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of…
-
1 PDF that requires two signatures, not sure where to start, kindly help?
Hi all! I'm looking for some very basic help to get started as I'm not sure where to. I have a single PDF form that requires two signatures. The first signature should be from an employee, say "x". The second signature then needs to be of that employee's supervisor, say "y". Once both folks sign, that form needs to go to…
