Cell linking
Discussion List
-
How do I create a report that sums totals from my sheet?In Using SmartsheetHi, I need to create a report that sums up the totals of each quarter on a report. How do I do this? I would normally use a pivot table in Excel for this, but I'm not sure how to recreate that same functionality in Smartsheet.Answered - Pending Review 931 views 3 comments 0 points Most recent by Bassam Khalil Using Smartsheet
-
Ability for PM's to select which projects they want to receive a status update request e-mailIn Formulas and FunctionsOn an ad-hoc basis I need project managers to be able to select which project(s) they want to receive the status update request so they can update accordingly. Currently In my dashboard I give them access to a separate "project select…Answered - Pending Review 9 views 2 comments 0 points Most recent by Jason Duryea Formulas and Functions
-
Is it possible to automate link creation between 2 smarthsheets?In Using SmartsheetRegarding the question above, consider a scenario where 1 project requires 2 linked smartsheets. Now consider a scenario where 50+ projects each require 2 linked smartsheets and a new project is added to the que 2 or 3 times a week. Is …
-
Returning the most recent value that matches multiple criteria (cross-sheet lookup)In Formulas and FunctionsHi All, I am trying to create a preventative maintenance schedule for our fleet vehicles and heavy equipment machines based on the vehicle/machine, the most recent odometer readings or machine hours, and the type of service needed (PM Serv…Answered - Pending Review 32 views 2 comments 0 points Most recent by Robert Bennett Formulas and Functions
-
Frozen/Unresponsive SheetsIn Using SmartsheetWe're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
INDEX COLLECT or VLOOKUP not working with numbersIn Formulas and FunctionsI am in need of some help with trying to use either the INDEX/COLLECT or VLOOKUP functions. I have tried everything I can think of and nothing works. By employee number, I want to return their tenure. Both are contained in a reference shee…
-
Returning data from another sheet matching on two criteriaIn Formulas and FunctionsI am trying to create a report which brings back the actual performance for performance measures for the last month, 2 months ago and three months ago. But am stumped as to how i can do a lookup to the base data sheet using two criteria (M…Answered - Pending Review 14 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Join collect with other sheetIn Formulas and FunctionsI'm trying to use the best formula that will basically say.. If Distributor Name (sheet one) = Distributor Name (sheet 2), then input contacts (sheet 2) into contacts (sheet 1). There are multiple contacts on separate rows for each distri…
-
Quickbooks & SmartsheetIn API & DevelopersSo. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
-
Form DataIn Using SmartsheetHello totally new user to Smartsheet and need help on creating a form. I have looked at the posts but haven't found the answer, please help. 1) I need to create a form that will be filled by users to sign-up for different games. On the fo…
