Greetings I have been trying to figure this out for a couple days now. Let's say I'm trying to get expiration dates for fruits, which is 1 week after they are bought. However, if I have two apples (in…
How can I make my smartsheet pull columns of information from another sheet? The data I want to have duplicated is entered first on a vendor intake sheet, the two columns I want to 'link' or duplicate…
Hi, new to managing projects on Smartsheet. Current struggle: Sheet A and Sheet B have "Vehicle Identification Number" columns with unique values for each row. Sheet A has an "Order ID" column, which …
Hi Smartsheet Community, I am attempting to create a meeting planning set of sheets, and I am struggling with the following. SITUATION: Provide a formula for referencing a stakeholder register sheet f…
Hello Smartsheets! Trying to find a solution when matching rows across sheets. Is it possible to say, if multiple criteria in columns match criteria in multiple columns on another sheet to check a box…
I have an issue that I've seen in other discussions but I have not been able to figure it out for my situation. I want to automate the process of linking cells from one smartsheet to others. I will pr…
Hi smarties, I have 40 metric sheets (one per location). In each sheet I have an countif formula that references a data sheet. I have this formula in about 20 columns. A sample is in the screen shot. …
I have 2 Smartsheets. Sheet 1 contains the data. Sheet 2 is a helper that I use to drive a dashboard. In sheet 1 I have course names. I don't want to have to explicitly code for each course as new cou…