-
Smartsheet Charts with parameter
Hello Community, Anyone familiair wiith the charts via https://smartsheetlabs.com/ ? Is there a way to feed a chart with data without having to make a new sheet or report for every chart ? Example: - within 1 sheet I have a project which has several taks, each with planned hours and actual hours. - in a separate website, I…
-
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…
-
Multiple Sheets - SUM Dollar Totals in Report
I did a quick search in the community and didn't see this answered exactly, but i think either an Excel export or a future release of Dashboards may provide a quicker/better solution. So here's what I'm trying to solve. I've got 10 sheets that track Paid Claims. When the Claim is paid, a field titled "Date Payment Received…
-
Default Symbol Labels
I am using standard symbols in a drop down box. They have the default lables 'Yes, No, Hold'. Is there a way to change these default labels within this sheet?
-
Coordinating multiple projects and sharing sensitive documents selectively
I have 5 vendors working on a project. All five vendors have tasks which are significant projects in their onw right. There are interdenpendencies. I want to coordinate the project in a way that there is one gantt chart for the overall project which all vendors and their teams can see, their project managers can edit and…
-
exposing a report in the email body
First time posting here so apologies if this has been answered. I've searched through the posts and wasn't able to find an answer. I'm trying to move over to Smartsheets from Google Spreadsheets for a few reasons but mainly for the automated reporting. The one thing I noticed is that I can only send a report out as an…
-
Building a report or form that allows the user to query for a row?
We have been thinking of creative ways to allow users to manage just what is their responsibility without the added risk of someone fat fingering a change to a row that they do not own and the question came up if there was functionality to pull up data for a row similar to a DB query? We have users submit requests to our…
-
Trying to build a report, is it possible?
I'm trying to build a report from our company sales pipeline. Our pipeline has 7 sales stages. I'd like a report showing the percentage of our sales teams success progressing prospects from stage 3 or 4 to stage 5 (closed). At this point, I'm not sure how I need to approcae this report and build it. Would appreciate some…
-
Please add these features!
I now use Smartsheet as a huge part of my day-to-day work, I manage around 30 sheets at any given time (through mine and my boss' accounts). So there are a couple features I would really love to see added (and maybe I'm not the only one). -- Ability to lock comumns in a report - I need users to be able to see certain…
-
Report Builder
I would like to build a report from two sheets that uses the same number to identify items and fills the columns in that correspondes witht that number. For example- Take the UPC of one item and grab the revision date from one smartsheet and the backstock quantity from another smartsheet. I looked through help articles and…
