-
How to pull cell data from one sheet to another based on criteria
I have a sheet that tracks census of sheltered animals and I want to display that census cell in another sheet that matches the room number. I had a formula that pulled that but another admin had accidentally deleted some columns/formulas. In short, I want the data from the census cell to be pulled into another sheet with…
-
Can you parse a summary field from a report into another report?
I have a dashboard series of reports that have the sum of all room populations for the specified spaces in the report summary. Is there a way to capture the summary from these reports? I want to have a text box that displays these sums… I am trying to avoid having to setup yet another helper column to count up these spaces.
-
Returning a link if two cells are not blank
I need a formula that returns a specific web link to the cell at the row of my helper column ("Edit/Add Event") if my "start date" and "activity name" are NOT blank. Ideally, I'd also like the link to present as text: "Open Dynamic View". Appreciate any help!
-
Populating data into another sheet when certain criteria is met
I have two sheets that I need to work together - one for project tracking and one for expenses. When I change the "Payment Status" on an activity within my project tracking sheet to "paid", I want specific data from the row of that activity to populate as a new row in my expense sheet. The expense sheet should contain both…
-
Cross-sheet formula references in table view, now generally available!
January 22, 2026 Many users manage complex projects across multiple interrelated sheets and rely on formulas to consolidate data, calculate key metrics, and generate portfolio-level rollups. A critical part of this workflow is the ability to reference values from other sheets—commonly known as cross-sheet formula…
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Collect a unique identifier if a match is found
I am trying to use the collect formula with contains. Basically I want to use a unique identifier that is on one row and collect it to another row if the Teacher ID is contained in another row. For example: row 1: New Unique ID: where I want to formula to populate Unique ID: blank Teacher ID: 1234 Combined Teacher ID:…
-
Data String Type Different in Budget vs Time & Hours Data for Advanced Reports in RM
Is this a bug or just a limitation? When I create an Advanced Report based on Budget data in RM, the Data String type in Smartsheet is automatically a Date format. However, when I create an Advanced Report based on Time & Hours data in RM, the Date String type is Smartsheet is in Text format. Is there a way to have them…
-
When to use = and "" in COUNTIF formulas
I came across some weird COUNTIF functionality recently in one of my duplicate check column formulas. I wrote some exploratory formulas and wanted to share! Key Takeaways Numbers with leading 0s requires both = and "" Regular text requires "", but = is optional Regular numbers do not require = or "", but work with one or…
-
Add # days from a column to Invoice Date
I tried using AI which generated this formula. The error message I get is #INVALID COLUMN VALUE. Can an expert tell me how I can correct this please? The requirement is to take an invoice date column and add the value in a second column 'payment due in X days'. =[Invoice Date]@row + VALUE([Payment Due (in days)]@row )…