-
#UNPARSEABLE when using Cross Reference
I am trying to "simply" use data from one sheet and if the cell is Yes, it then adds another Cross Reference to the new sheet. If (Cross Reference: Refile Access) is Yes, then (Cross Reference: User Name). If Cross Reference: Refile Access is no, then nothing would happen. Both cross references appears as being used so I…
-
How can I convert a referenced created date to a numeric value in order to calculate time lapsed
I reference two created date fields from another sheet. I use the following formula to reference the created date: =IFERROR(INDEX({2a. FEMALE CHANGE ROOM Range 1}, MATCH(JOIN@row, {2a. FEMALE CHANGE ROOM Range 2}, 0))+ "", "") The result is displayed as 10/01/25 10:35 PM which is correct. My problem: I need to calculate…
-
Image workaround for Document Generator
We currently manage a detailed Turnover schedule for our Housing Facilities operation. The main schedule sheet has all of the schedule details (contractors, custodians, inspections). I currently have an automation to run the Document Generator every morning to create a custom sign-in sheet for Turnover workers. We would…
-
Multi-Line Chart from Imported Excel Data based on Counts Per Date
Hello! Got a problem that's confusing me because I'm used to Excel and can't find a way to do this on SmartSheets. Context: I have a CSV that I export from a database that contains info about design issues such as ID #, Status, Create on Date, Updated on Date. I'm using Smartsheets as a project management tool and I'm…
-
How do I write a formula to use multiple columns in a single cross-sheet reference.
I am trying to set up a "combined budget" sheet that will summarize multiple budgets while maintaining the heierarchy of the original sheets. Doing this on other solutions, I have previously just set up individual column references between each sheet (most projects utilize 2 separate budgets). This will not work on this…
-
Sum like data when information is stored in multiple cells on the same row
Hi. Any suggestions on how to sum data when it is stored across multiple columns? Each row contains up to three values and associated dollar amounts that come in via a form. I'd like to create a list of distinct values across all rows and sum the matching dollar amounts. Any suggestions? Thank you.
-
Need to reference distinct values from another sheet
I'm looking for a formula to automatically pull distinct values from a column in another sheet to use in a reference sheet. Example: Source sheet 1 has a list of [CustomerID] and various other columns. Some [CustomerID]'s are listed on multiple rows. Reference sheet 1 wants to list all the DISTINCT([CustomerID]) values, so…
-
Does VERY SLOW WiFi Break Cross Sheet Reference Calculations?
Our wifi is VERY SLOW today. I'm getting 20 Megabits down, but only .22 Mbps Upload speed. (NOT smartsheet's fault) When I am in a sheet that contains sheet references to another sheet, it APPEARS that the calculations change to true or false by themselves, with no other people making changes. I presume it's because…
-
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…
-
HELP! Formula to Find Matching Value Between two Dates in another sheet
I need help creating a formula that I thought would be easy but is turning out to kick my be-hind, and three different Ai’s aren’t able to give me a solution either. Formula Objective: Find the Report Name located on the Report Deadline sheet, using the [Pay Date]@row, which will be a date between two date values on Report…