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!
    Answered - Pending Review
    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…
    Answered - Pending Review
    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…
    Answered - Pending Review
    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…
    Answered - Pending Review
    27 1
    Answered - Pending Review 27 views 1 comment Most recent by Andrée Starå Using Smartsheet