-
Total number of inquiries is off by one
I am fairly new to Smartsheets and racking my brain trying to solve this problem and I am hoping the community can help! I have a log sheet that we use to keep track of inquiries received through one of our channels. I have the 'Inquiry type' column, that has the multiple dropdown option for all the different types, and…
-
COUNTIF is Not Working as a Sheet Summary Field
I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clearly are rows that meet the criteria. SHEET SUMMARY FIELD FORMULA: =COUNTIF(Fund:Fund, 160) Here is a sample of the data in my…
-
Finding the oldest date on multiple sheets and also based on text in another cell
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments will be in 2021, but some will be in 2024. A sheet summary formula is not what I am looking for. I need a reference sheet…
-
Copying a one cell to another between sheets
I am trying to copy a specific cell from my main sheet to another cell on a different sheet. I have tried using the cell linking feature where I right click the cell I want the information to go and select "link from cell in another sheet" then select the cell I want on the main sheet and select create link. When I do this…
-
Removing semicolon and pull multiple values from reference sheet
Hi, I have two sheets: Sheet 2 (reference sheet, see photo 1) and Sheet 1 (formula sheet, see photo 2). I've created a formula that works when the item number column is a dropdown menu with multiple selections. However, I need a formula that achieves the same results when the item numbers are separated by semicolons ";" in…
-
Hi! Can someone please help me with writing a formula for my summary field?
I need to count rows if “Target Start” is between the Friday before last Friday and last Friday, “Work Type” is "EMERGENCY”, “Work Order” does not contain “IMP”, “Status” is not one of “Cancelled” or “Closed - Out of Scope” I've tried: =COUNTIFS({Target Start}, >=TODAY() - WEEKDAY(TODAY(), 2) - 2,{Target Start}, <=TODAY()…
-
How to Import MS Project File into Smartsheets, but with the Time stamps from MS Project?
When I try to import MS Project File into Smartsheets, it automatically treats the import as a project and hence the result only appears with the Start Date and Finish Date, and I lose the time stamps in from my MS Project File. I also tried taking an export of excel file first from mpp., but as I export to Excel, I lost…
-
Reference cell value from a different Smartsheet
Hi Smartsheets community, I was wondering if anyone would know a way to reference a project ID from a separate Smartsheet by searching for Project name and returning the project ID. I was previously manually searching and linking them across the 2 smartsheets BUT: Sometimes new line items are added to the master list…
-
Merged: Provide method to disable "Used in formula" Pop-Up
This discussion has been merged.
-
Month Today formula for previous year's month?
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 instead of having to reference 2024 in the formula I can say year today minus one to reference that year. I'm curious is…