-
Calculating Sum of Hours from Child Rows
I am trying to sum up the "Total Hours Used" from Child rows (white highlighted) into the "Total Hours Used" parent row (black highlighted). I cannot use StartTime and EndTime here, because the time slots are not necessarily continuous. Appreciate any inputs on this. Child Rows - "Total Hours Used" Calculated as 2 hours, 4…
-
Search Bar Question
Is there a way to add a Smartsheet search bar to a web site, linked to my smartsheet?
-
Need a Work Around Please
I have an Admin who doesn't wish to share the sheet with me so I can add a column to covert the date in the date column to a Weekday, Is there a way to do this on a separate sheet? Our, Both the Admin and I, have superiors who want me to create a report showing the total orders scheduled by day of the week and then I have…
-
RYG Automation using IF/AND function
Hi, I am creating a project management sheet with RYG symbols to trcak our progress. I have a sheet with the projects, status and due dates. What I'm trying to achieve is for the RYG symbols to automate based on the status and deadlines. If status is either in progress or for review, and is 2 days before the due date,…
-
How to create report with rows instead of columns?
Why does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals, etc) and I need to take information from only certain rows to create a report for…
-
Notification only show changed cells
I am sure this should be possible but can't find any direct reference to it: I have set up notifications and approvals in a workflow as consequences of a request for updates. I would like the notifications (and/or approvals) sent after that update to include only the cells that were updated, in exactly the same way that it…
-
Report using multiple sheets
Hi...I would like to build a report from 2 sheets. Taking most of the columns/rows from the first sheet "Summary View" and then just one column of data for the color the RYGB color status from the "SP Automation -Internal" sheet. I have tried to add this missing data point into the "Summary View" sheet but I am at the max…
-
Send a link to a report to users that have tasks due that day
I'm not sure what the best work flow is for this but here is my current setup: * I have a task list with all tasks for the duration of a project. * I have reports that list all tasks due within the next day or week for the "current user" * Currently users get alerts for every task that is due on that day (multiple alerts /…
-
Automation in Smartsheet-Responding to automated updates
I have workflows that automatically send update requests to my vendors when a task is 48hrs from its completion date. However, when they respond it goes to automation@smartsheet.com, and not to me where it should be? How can I change it??
-
Dashboard Metric Sheet Index Collect and Week # format
We are having some issues with our dashboard linking abilities. We have a cost summary sheet that is updated weekly and our current set-up involves the values entered in the cost summary linked to a dashboard metric sheet with the "today" function tied to the week # function in order to have the $ values automatically…