-
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…
-
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 )…
-
new GRANDPARENT() function
I would greatly appreciate a Grandparent function, especially since PARENT(PARENT()) throws an error. I know we have ANCESTORS(), but that gives you the number of ancestors and I need the specific ancestor value. Ideally, the GRANDPARENT() function would be GRANDPARENT( [reference], [# of generations back] ), that way it…
-
Using report information in a new sheet
I am working on creating a streamlined way to obtain information from our 66 non-profit groups in order to request specific credentials based on what zone their group will be working in. I only need full name and email addresses from the group leads. All other information needed, I and operations managers would enter. I…
-
Merged: GRANDCHILDREN Function
This discussion has been merged.