-
Counting quantities from another sheet that correspond with a reference on original sheet
Hi folks Really need siome guidance. I've tried the AI tool, but not getting anywhere. We are carrying out a network audit at multiple sites. I need to be able to display the SUM from another sheet when it meets the critera from current sheet: For example, I want to bable to display a summary of additiopnal switches needed…
-
Count if Container Code is Unique
Hello, I have a metrics sheet that is referencing another sheet to count how many counts of a specific Hold/MECQI Reason =COUNTIFS({Hold/MECQI Reason}, CONTAINS("incorrect container", @cell), {Hold Issuance Date}, >TODAY(-180), {Hold/MECQI Reason}, NOT(ISBLANK(@cell ))) I only want it to count if the corresponding…
-
Checking two conditions then populating a reference from another sheet
Hi all, I am trying to cross reference between two sheets based on certain conditions. The two conditions on one sheet will then be checked against a master list to populate a column on the original sheet. Specific example is as follows: The original sheet has columns for the following Assay Type* = PNG Task = SAP I want…
-
Circular Reference
I am working on a RAID log and want the "Next Action Owner" column to be filled in with the name in the "Created by" column if people do not add a name in the "Next Action Owner" column. Is there a way to edit the formula that I currently have in the "Next Action Owner" column to have this done without receiving a circular…
-
COUNTIFS & CONTAINS (cross sheets)
Trying to count following: Any row on reference sheet in the YEAR column that is equal to "2025", CONTENT TYPE ="US" (dropdown column, single select), TEAM = "EU4" (dropdown column, single select), CRITERIA column contains "Pan-EU" (dropdown column). I have tried everything and works fine until I use Contains. I get…
-
Check Box Across Sheets
Hi, I have two sheets, one is an intake sheet and the other is a metrics sheet. Metrics Sheet Plan has an OR(ISDATE( Formula to raise flag is a date is entered Agents has an IFERROR(INDEX(DISTINCT formula to capture the agents from the Intake Sheet Intake Sheet I want to add a Formula that can Raise a Flag under the PLAN…
-
All Cross Sheet Reference has been deleted automatically from Smartsheet
Dear Smart Team. Suddenly all Cross Sheet Reference has been deleted automatically from Smartsheet which impact all business users. Even in the logs is not showing any activities. How Can i rectify and fix this issue. Is there any way to retrieve all references without re-creating again. Please note that yellow highlighted…
-
Child Row Formula to Reference Parent Row
Hello! I'm trying to figure out a formula that will always reference the Parent Row. I need all the cells in the Practice Name column to reference the parent row above it. I'm assuming I can't make this a column formula, otherwise the parent row I need to reference will be referencing the parent row above that. So for…
-
Can I set a cell equal to all data from a column of another sheet?
I want to pull a whole column of data from Sheet1 into a single cell on sheet2. The name of the column on sheet 1 is "Emails". I can't get a formula to work. cell formula something like ={Sheet1!Emails}? I am pretty new to Smartsheet formulas.
-
Help referencing checked boxes in another sheet
I am currently trying to pull information from an intake form directly into a project task sheet based on which boxes the user checks for individual project needs. The form has an automatic number field that sets the project request number, and the goal is to be able to simply add that request number to the correct cell in…
