What I would like to do is create a formula that will copy the information in the cell above it if the 'X-code Details' is chosen in the pick list in the column next to it. If General Run Details is i…
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The form…
The 'Latest Comment' column is a great feature to add the most current information into sheets and reports. It's helpful to be able to provide our executive team printed reports containing all of the …
Hi everyone, I'm hoping someone here can help me out with a challenge I'm facing in Smartsheet's Data Shuttle. I've been trying to use expressions to combine two columns into a single dynamic dropdown…
Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we nee…
I have installed Smartsheet add on for Gmail and I would like to know how to set it up to show only certain columns for one of the sheets based on the access or on how to set it up as currently it sho…
I'm determining how long a person has been parked based on the parking lot zone number and the amount of money paid. I have a separate reference sheet that lays out the zone numbers, location names, a…