Cell linking
Discussion List
-
IF Function (related to dates)In Formulas and FunctionsHi @ 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…
-
Pivot: Add Row Links from source sheetIn Premium Apps and IntegrationsWe'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 views 1 comment 0 points Most recent by Kelly Drake Premium Apps and Integrations
-
How do I have a Dashboard show only 100% not 150%In Formulas and FunctionsPlease 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 views 2 comments 0 points Most recent by Jennifer G. Formulas and Functions
-
Volunteer AllocationIn Formulas and FunctionsHi 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…
-
CountIF for a multi-select drop-downIn Formulas and FunctionsHello, 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 views 3 comments 0 points Most recent by David Joyeuse Formulas and Functions
-
Formula/pie chart help?In Formulas and FunctionsI'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…
-
Summary reporting with conditional formattingIn Formulas and FunctionsHello! 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 views 4 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Counting and Averaging with ExclusionsIn Formulas and FunctionsHello 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 views 2 comments 0 points 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 SmartsheetHello 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…
-
Column Number FunctionIn Formulas and FunctionsHi 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.
