I have a source sheet with hundreds of rows of entries. One of the columns is named Property. There are many different values under this column. I have a destination sheet for each one of these possib…
I help develop Smartsheet sheets and reports, and link cells from project plan sheets to an overview portfolio sheet. Recently I've seen where some cells link properly, but some cells don't. I've trie…
I have users completing a form to update a source sheet I use for a Dashboard. Once the sourcesheet is updated I would like to show the latest update in realtime with having to update the dashboard ma…
I'm fairly new to setting up my own SmartSheet pages and was wondering if this would even be possible. Is there a way to link a Date column to a check box or a drop down item? For example- I want to h…
Hello Everyone: I have an "Assigned To" column on a standard task list that is linked to a Project Directory. My goal is to be able to link the "Assigned To" column to the applicable role that is fill…
Our Smartsheet has been build with time entered that way 2h00 0h15 0h15 1h00 3h00 2h00 1h00 0h15 0h15 3h00 0h30 18h00 I want to transform that value automatically in minutes (120 / 15 / 15 / 60 / 180 …
Is there a way to publish and embed a sheet's data onto another page with only certain columns? Example - Sheet has Sprint milestones and Notes column with Gannt view. We are using Confluence/Jira too…
I have a google form that updates the prices of materials. On google sheets to display the most updated price of the material I have a Newest Entry Column =MAXIFS(Timestamp:range, Material cell) then …
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep gett…
