Cell linking

Discussion List

  • IF Function (related to dates)
    In Formulas and Functions
    Hi @ all, I have a formula issue where I would like to get your help. (Image) As you can see I have a delivery cell which I would like to link to my "Financial Year" cell based on the following condition: FY2020 = starting 01.0…
    Accepted
    8 2
    Accepted Answer 8 views 2 comments Most recent by Nico Kanthak Formulas and Functions
  • Pivot: Add Row Links from source sheet
    In Premium Apps and Integrations
    We're starting to dive in a make use of the Pivot app, and it is extremely powerful, however we are finding that it would be extremely useful for users to be able to affect the base data from the Pivot sheet more easily. One idea I have w…
    Answered - Pending Review
    5 1
    Answered - Pending Review 5 views 1 comment Most recent by Kelly Drake Premium Apps and Integrations
  • How do I have a Dashboard show only 100% not 150%
    In Formulas and Functions
    Please see below example. I want to only show 100% as the top, not 150%. Is that something on the sheet itself that I need to do? If so, I only have a % Complete and % Remaining columns. What would i need to place in there to fix this. (…
    Answered - Pending Review
    3 2
    Answered - Pending Review 3 views 2 comments Most recent by Jennifer G. Formulas and Functions
  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    64 3
    64 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • CountIF for a multi-select drop-down
    In Formulas and Functions
    Hello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because i…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by David Joyeuse Formulas and Functions
  • Formula/pie chart help?
    In Formulas and Functions
    I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dash…
    Accepted
    13 1
    Accepted Answer 13 views 1 comment Most recent by Sean Morgan Formulas and Functions
  • Summary reporting with conditional formatting
    In Formulas and Functions
    Hello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with c…
    Answered - Pending Review
    24 4
    Answered - Pending Review 24 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Counting and Averaging with Exclusions
    In Formulas and Functions
    Hello Smartsheet Community, My organization uses Smartsheet to track our recruiting efforts. Each of our divisions has its own sheet, and we have a metrics sheet to tie all of the divisional sheets together. I am having issues both at the …
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • How can I create new entries/rows and make sure the link's rule applies automatically to them all?
    In Using Smartsheet
    Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Column Number Function
    In Formulas and Functions
    Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
    233 4
    233 views 4 comments Most recent by David Joyeuse Formulas and Functions