or Explore Discussions

# Solution Center

## Discussion List

• Move Attachments Only sheets to sheets
In Formulas and Functions
From reading other posts I don't think this is possible.... is there a way to copy only the attachment from one sheet to another? I do not want to copy rows. Enhancement request for this function please!
23 1
Answered - Pending Review 23 views 1 comment Most recent by Andrée Starå Formulas and Functions
• Maximum cross-sheet references
In Formulas and Functions
Once you reach this figure of maximum cross sheet references how can you get around this. I want to configure calculations to 2030. Got to June 2025 before I got stuck.   Regards Steve
210 8
210 views 8 comments Most recent by Paul Newcome Formulas and Functions
• NEW! COUNTIF not blank....
In Formulas and Functions
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
38 1
Answered - Pending Review 38 views 1 comment Most recent by Mary Royston Formulas and Functions
• Help on formula: count if with multiple criteria
In Formulas and Functions
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
13724 50
13.7K views 50 comments Most recent by Paul Newcome Formulas and Functions
• Help with counting formulas and exclusions
In Formulas and Functions
Hi there, I'm trying to create a formula that would count all instances where a certain option is selected from a Multi-select drop-down and then it would subtract any instances if a certain category has been selected in another column. F…
18 1
Answered - Pending Review 18 views 1 comment Most recent by Paul Newcome Formulas and Functions
• Fiscal Year Calculation
In Formulas and Functions
Hello, I am trying to have a column that calculates a fiscal year automatically based on whether the parent Completed Date falls before or after July 1. Something that follows this logic: If the parent "Completed Date" month is…
Accepted
65 10
Answered ✓ 65 views 10 comments Most recent by Paul Newcome Formulas and Functions
• Formula: if checkbox is checked then add or subtract
In Formulas and Functions
Hi everyone, I would like to have a sheet that tells me how many goods we have left in our warehouse.  The idea is that employees report via a dashboard whether they are taking something out of stock or returning something.  If one checks …
Accepted
43 4
Answered ✓ 43 views 4 comments Most recent by Genevieve P. Formulas and Functions
• Triggering a Workflow on existing data
In Using Smartsheet
Hello, I can't seem to figure out how to trigger a new Workflow on an existing data set. I created a Move Row Workflow that is triggered by a change in my Status column and where there is a date present in another column (two conditions)…
169 5
169 views 5 comments Most recent by Andrée Starå Using Smartsheet
• VLOOKUP with IF and IFERROR Formula
In Formulas and Functions
I need to figure out the VLOOKUP formula within the Barrier Management Survey Status Sheet to where IF the Services Completed is “Door Program” (within the Shared Services Program Survey sheet), and the Facility Name matches, to then pull …
Accepted
27 3
Answered ✓ 27 views 3 comments Most recent by Ashley Pierce Formulas and Functions
• Personal consultant
In Using Smartsheet
Hello Everybody, I need assistance for building a solution for my company with smartsheet, I'd like to know if I can have support by a freelance expert or a partner. I'm in Italy, so it would be great if we could speak italian, but in engl…