Hey 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 title…
When 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. …
I 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 no…
Hello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) Al…
I have a service request sheet with an index/match formula to assign a person based on request type. My formula works for all request types except "External Communications" - it assigns the wrong pers…
I'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet fir…
Hi, I have two columns ID and C. Based on a vlooup formula in C with the search value in ID and need to show the value in C. My Question here is when I need to show multiple values based on multiple I…
Hi all, I have two sheets that are connected via multiple cell links. When adding/deleting a row in sheet1, all the cell links break (#INVALID DATA TYPE). To make the links work again I have to go int…
OK I am new to building formulas like this and everything I keep trying gives me errors like "UNPARSEABLE" and "BLOCKED". How would I set up a formula for this? If the "Is there a color image?" box th…
I don't think this is an option, but here goes. I have a form connected to a smartsheet that references another smartsheet to autopopulate text information based on a selection in the form. Instead of…
