-
Stop Formula reference from applying to whole column/sheet
Hello, I have a formula I am trying to apply to only certain cells. See below: =IF(ISNUMBER([Column15]@row), IF([Column15]@row >= {LL5}, "5", IF([Column15]@row >= {LL4}, "4", IF([Column15]@row >= {LL3}, "3", IF([Column15]@row >= {LL2}, "2", "1")))), " ") Then I want to copy and paste this formula to a different cell on the…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Update a referenced sheet without individual column formulas
HI, I have a master sheet that feeds data into a helper sheet. I want the helper sheet to automatically update whenever the master sheet data changes. Is there a way to sync all columns based on a unique row ID (to avoid pulling in the duplication of rows), without having to write individual formulas for each column? I've…
-
Using sheet reference to build placeholder text for an email alert
Hi I am attempting to build placeholder text for an email alert but I want to do it on another sheet referencing the data on my master sheet. It will include text and cell references. Basically I'm trying to write something like the following. "Hi name, Cardholder has made a purchase at Vendor for $XX.XX. Please review and…
-
#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.