Cell linking
Discussion List
-
Is it possible to count the number of entries in a column for the current work week, and quarter?In Formulas and FunctionsIs it possible to count the number of badge IDs in a column for the current work week, and a quarter? I need to track the progress of a weekly target that resets every Friday. Currently, I can not get the CWs (blue) to align this is my sta…Answered - Pending Review 28 views 1 comment 0 points Most recent by Jeff Reisman Formulas and Functions
-
Intake sheets add on process flow task management aligning with project planIn Apps, Integrations, and Add OnsI am setting up a sort of hybrid project with a large cable manufacturer, the project started and stopped during COVID and they had no task management. I am to use SmartSheet for the project plan, which I have mostly in place other than si…Answered - Pending Review 61 views 1 comment 0 points Most recent by Genevieve P. Apps, Integrations, and Add Ons
-
Metrics: Using the metrics template and metadataIn API & DevelopersI have the following setup: An Individual Project (Individual) A Dashboard Rolling Up Projects Assigned to an Individual (Program) A Dashboard Rolling Up All Projects (Portfolio) Each of the Individual, Program, and Portfolio has a metada…
-
How do I create a Index/Match formula w/ a condition across sheets?In Formulas and FunctionsI have a sheet with a bunch of site location data. This sheet includes a check box column showing if the site is Open (Checked = Open). I have another Project sheet where I want to pull in only the OPEN Sites and populate 3 columns from t…Answered - Pending Review 24 views 2 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Summary FormulaIn Formulas and FunctionsHello, I am using Smartsheet for project planning. I would like to track adherence to plan, specifically counting the average of the Start to Plan and Finish to Plan and represent the number separately as a percentage so I can see what …Answered - Pending Review 39 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Multiplication FormulaIn Formulas and FunctionsHi, I have two columns 'Likelihood' and 'Current Maximum Impact'. All I want to do is multiply them together, can anyone help please? ThanksAnswered - Pending Review 15 views 8 comments 0 points Most recent by Andrée Starå Formulas and Functions
-
Why is one sheet workflow bringing the cells to the top and 1 sheet is bringing the cells bottomIn Using SmartsheetI have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.
-
Linking checkboxes across 2 sheetsIn Formulas and FunctionsI've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered dat…Answered - Pending Review 833 views 13 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
IF FunctionIn Formulas and FunctionsHi, I want a formula to report if the Actual Start date is greater than the Baseline start then put the tick and cross symbol. The formula works however even when there is no actual start date entered it will still populate. I need a co…Answered - Pending Review 25 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
How to link a checkbox from a checklist to a column in a Report?In Formulas and FunctionsI was wondering if someone could please help with linking! I have attached two photos for a reference. One is of the checklist (which is the one with the rows) and one is the report (which has all the tick boxes in the columns). I am wanti…Answered - Pending Review 61 views 4 comments 0 points Most recent by Genevieve P. Formulas and Functions