-
SUMIF formula for adding up in a date range
I have a sheet that I am using to collect a list of items weights and have multiple per day. i want to capture all the weights that are today and for the next 5 days and sum them up if possible. Currently i have tried this formula =SUMIF(Date:Date, <=TODAY(), [Qty (ton)]:[Qty (ton)]) but this includes all the past dates,…
-
Creating a Chart from Non-Numerical Data for a Dashboard
I would like to have a pie chart on my dashboard that displays percentage of types of activity from a column in a sheet. More specifically, I have a column in an IT tracking sheet that has a dropdown menu. I would like to be able to display on a dashboard the percentage of each activity in the sheet. (e.g., a pie chart…
-
COUNTIFS formula using dates excluding weekend days
I'm trying to figure out the correct formula for counting up the # of entries for a particular location with a "YES" or "NO" data entry for the previous date, TODAY (-1), that doesn't include weekends. For instance, if today=Monday, then the formula would need to search for the previous Friday date and count the # of…
-
Smartsheet Consultants Needed
Hi community, Our organization just purchased Smartsheet Enterprise License - and is looking for consultants to build the solutions which require API integration. We have contacted with Smartsheet internal team and they quoted us $12,900 + extra travel expense, just for 2 days on-site "discovery and planning workshop",…
-
Unable To Change Workflow Option To Run Hourly.
Hello, Is there a reason why my workflow will not save when I select to run it "Hourly"? The only option that works is "When Triggered". There is nothing that is telling my I need to add information (no red boxes). I click save and nothing happens.
-
SMART Sheets for branch audits
Can anyone support? I want to use smart sheets for auditing several branches in our company. Has anyone done this and can share an example?
-
Cross-Link Dependencies
2 issues How to cross-link dependencies between separate project management sheets How to see these cross-link dependencies in a summary sheet I looked into these 3 sites for cross-linking dependencies, but I've hit a wall with resource management https://www.smartsheet.com/blog/support-tip-cell-linking-master-gantt…
-
Live Dashboard Presentation
Hi all, I am needing to present a few of my dashboards, in real-time, on a 24 hour cycle. I will be presenting about four individual dashboards but I am running into a bit of a snag. I tried using Revolver Tabs in Chrome, but when the tabs rotate it auto-refreshes the new screen which causes the full screen mode to…
-
WBS numbering and work arounds
Good afternoon Smartsheeters ;) I am only new to Smartsheet and have started working on some existing docs. We have a very clunky and manual way of applying a designated PRIORITY number. When the sheet for each project/group of projects is first started, its easy - everything is labelled from 1,2,3,4,etc til the last row.…
-
Populate date fields per status changes
Hi, I am running into an issue with populating date fields per status change. I have two date fields that reflect per status change. For example: If status change to "option 1" change this date field to today's date. If status should change to option 2 change second date field to today's date. What I have currently:…