I have a request to create a way to track a certain record's time since it's been opened, but the user would like the tracked time to not include when it's in a certain status. For example, if the record is in "Open" status for 2 hours, have 2 hours tracked. If the same record is changed to "Waiting on feedback", however…
I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
I have two columns: Column One: It's a multi-select dropdown list with the names of products (the quantity of selected products can be very long) Column Two: It has the quantities of each product in the same order as Column One, separated by commas. Example of one row: Column One (dropdown list with multiple choices):…
For all exams listed on our Assessment sheet , if no incidents during the exam occur, is there a way to streamline by cross-referencing the Assessment sheet to populate specific columns in the incident report sheet instead of completing a separate report? I'd like a user to go into the assessment sheet, scroll to the…
Hi all whats the best way to convert this tracker on smartsheet any ideas will be appreciated @Paul Newcome tagging as always for your advice please
Hello, I am trying to track data by year for different buildings. I have three pieces of information that need to be tracked per year. Is it possible to group columns together to signify that they belong to a certain year? Thank you
I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…
I'd love to be able to add a hyperlink to a cell that links in a value from another sheet. Currently we're unable to do this as linking cells blocks the ability to add a hyperlink. This would add more versatility, particularly with trackers, as you'd have the ability to pull in valuable information while also linking to a…
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…