-
Manpower Loading Schedule
I am trying to create a Project(schedule) that has a manpower loading functions. I am almost there but I am stuck with trying to figure out how to see how many crew members I have on a certain days by suming them up. For example I would like to have a list of dates and then show how many crew members working on those…
-
Creating a report using COUNTIFS with multiple fields and date range
Hi: I have a schedule Smartsheet that I am attempting to build a report via COUNTIFS formulas which pulls data from the schedule smart sheet. My schedule smartsheert (source data) has the following fields & Column Values, I'm using to attempt this report: Individual Names (Text), Status (Text), Start Date (Date), End Date…
-
Countif not containing specific text
I am trying to create a formula to count "Red" based on one column but not include certain ones which contain the text "Spring" in another column but I can't get it to work. Originally I tried this formula: =COUNTIFS([Aging]:[Aging], "Red", Project:Project, <> "Spring") However, I realized that won't work because the…
-
Sum based on drop downs across multiple sheets
I have multiple sheets that all lead to a "Totals" sheet on the first sheet. This project is based on caseloads in a school system. Each "sheet" is its own school in the system. I have a drop-down on each sheet for the speech teacher for that school, as well as total hours of service time needed at each school/week. I need…
-
Formula off multiple columns
I'm trying to build a formula that works off multiple columns to give one of the 6 state pain scale results (No pain -- extreme pain). Here's my formula:IF(Cancel@row = 1, "No Pain", IF(Suggested@row = 1, "No Pain", IF(TODAY() - [Date Requested by School]@row > 14, "Extreme", IF(ISBLANK([Airline Contract Attached to…
-
"The source data for this chart has changed" - Charts with Zero Values
Hello. I have noticed that charts within a dashboard do not display and throw up a message: "The source data for this chart has changed" when they are pointed at sheets or reports where the value is zero / 0. This is problematic for me since I have created a dashboard for a template set of sheets and reports, and…
-
Creating workflows for repetitive tasks in Smartsheet
Hi How do I automate the workflows in smartsheet for repetitive tasks? For example Scenario 1: The issue has been raised by Testing team - which goes to the Development team, they modify the code, Testing team tests the modified code - if the issue is resolved, the issue is closed, if the issue is not resolved the cycle…
-
Pull in average of column for certain rows in sheet
I have a tracker setup that I track support requests. I have a few metrics that allow me to see AVE SLA time to completion and assignment. The problem I am having is I want to show this same AVE SLa time value BUT only for specific rows based on a value in one of my columns. I seem to have a mental block on how I can…
-
Calculate a conversion rate on a specific date
I have a budget that has expenses in both USD and EUR. I report expenses in USD to our finance department. I'd like to be able to calculate the euro to usd conversion rate for the date that something is paid. Is there a formula not to pull the current conversion rate, but a conversion rate from a specific date, in this…
-
Joining Formatted Cells
Hello All, First time caller...Is it possible to join cells where text in those joined cells have different colors and have the joined cell retain all the various text colors? I've tried =Cell1 + Cell2... and =Join(Range) and both return combined text in default black text. Thanks in advance for your feedback. DT