Cell linking
Discussion List
-
Help using a multiple cell criteria from a source sheet to auto populate a formula sheetIn Formulas and FunctionsI'm stuck. Really stuck. I've attempted more than 30 formulas. I hope someone can help me. I am using a master HR data file with 1500+ rows (reference/source sheet) to auto-populate a training enrollment roster (formula sheet), only I don'…
-
Auto populate data in FormsIn Using SmartsheetI am trying to auto populate the data in Forms for example if we select ID the corresponding fields will get auto populated with required values. As per the attachment if we enter any ID in the CUS ID field it should populate the PSS Firs…
-
Cell Linking from a FormIn Using SmartsheetHello I am trying to do cell linking from when the information is entered in from a form rather than directly onto the sheet itself. When I do this it adds the information onto the sheet however it moves the cells I am trying to link down…
-
Report not updating after source sheet is edited and savedIn Using SmartsheetHi, I am trying to update a report but whenever the source sheet is updated and saved, those updates do not filter into the report. I have tried waiting to see if it just takes some time to update, refreshing both sheet and report, closing…
-
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 508 views 10 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Using a profile matrix to drive automation on specific datesIn Formulas and FunctionsI have a profile matrix that has a set of dates across the top (columns), row 1 and then a list of product types (Student, Teacher, Classroom) for each record, starting at row 2. On a separate sheet I have a list of products that associate…Answered - Pending Review 31 views 3 comments 0 points Most recent by Paul Reeves Formulas and Functions
-
Can Formulas Reference Reports?In Formulas and FunctionsI'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
-
Multiply cell by 2 if checkbox is checkedIn Formulas and FunctionsHey Smartsheet users! I've read through a lot of check and IF formulas and haven't been able to find my answer so here is the situation. This is for a mileage reimbursement form. I have a column titled "Mileage" and another colum…
-
Cells Not LinkingIn Using SmartsheetWhen I copy cells from one sheet and paste them onto another, I right-click and want to use the Paste Special > Links to Copied Cells option, but it's often grayed out. Not sure what I'm doing wrong. It worked for the first 20 cells and…
-
if checkbox is checked, capture a value from same row and populate separate sheetIn Formulas and FunctionsI would like to capture values from specific rows on a source sheet (Estimate Summary) when a check box is checked and send those values to a destination sheet (Allowance Log). When the checkbox is not checked on the Estimate Summary shee…Answered - Pending Review 12 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
