-
Report Request: Show new discussions added within a time period
I would like to be able to publish any rows that have recieved new comments over the past 7 days along with what those comments are. Is that possible?
-
Counter on Report
Is there a way to add a column to a report? I have multiple SmartSheets managing Test Scripts in multiple functional groups and I want to create a bug report for the developer that searches them all and only shows them the "Fails", but I would like the failures to get a unique identifier. Is it possible to add a column…
-
Setting up alerts on a Report
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.
-
TICKBOXES IN SMARTSHEET
I am trying to record telemarketing results for multiple users, who want a simple sheet to "tick" one of four boxes as to the quality of the call, every time they make one. This needs to be automatically updated, and centralised onto a single sheet, with the ability to breakdown into user and date. Ideally, we dont wish to…
-
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…