-
Creating Pie Chart with Non-numeric values
Hi, I would like to build a pie chart that reflects some number of red, yellow and/or green status in a bug tracking sheet. Since pie charts seem to require numeric data, I think that I need to craft a formula that will assign value of 1 to all colors (RYG) then count how many there are of each color. This way, when I look…
-
Conditions / Rule formula set-up
I am working on a sheet, and I am very new to this application, where I am tracking P.O.'s, date ordered, date received, etc... and I have 2 columns (at the far right of my sheet or end) that I would like to If the P.O. Total is < or = to the Invoiced Amount the cell would turn green and if it was > than to turn the cell…
-
Duration roll up values not displaying accurately
My duration roll ups for child/parents are not working as expected. Can anyone advise of things I could try to resolve why only one parent has a duration total?
-
Formula to check if cell contains text string + value in another cell
For example, the value in column 4 row 2 is "xxxxx_email address=test@test.com_xxxxx" The value in column 2 row 2 is "test@test.com" I need a formula that checks if column 4 row 2 contains "email address=test@test.com" by crosschecking the value in column 2 row 2 and using the text string "email address=" I have it worked…
-
Furmula Not Working Properly
In the following Formula if I use ="Completed" I get the correct Count back. If I change it to <> "Completed" I get 0 returned where it should be 37. =COUNTIFS(Status:Status, <>"Completed", [Due Date]:[Due Date], >DATE(2018, 11, 25), [Due Date]:[Due Date], <DATE(2018, 12, 3)) Any ideas? Thanks, Bill
-
if - and formulas auto populating checkbox
I've created a column titled "Outstanding Approvals", I would like the column to auto populate the check box when "Approval Status" is empty AND when "Start Date" has already begun. I'm using it so I can pull multiple sheets into a single report - but not all the sheets have the same layout. Any help is great! thanks in…
-
Date formula question
Good morning, we have a sheet we are using to track leads. I've been asked to set up an automated update request to send leads that have a certain status out on the first business day of each month. In the automated actions, there is no way to set a recurring update request like there is on the row-level update request. So…
-
Using SUMIF Formula Help
Hey everyone! I just started using Smartsheet and so far am blown away by everything! At the moment, I'm trying to use the SUMIF formula to calculate a total cost but only if the number being used is below 0. For example, If Column A is a negative number, I need the formula to subtract it from Column B, however, if Column…
-
Formula that will automatically add $25 to the cell
tracking installations of certain units. When unit install gets cancelled checkbox for "unit cancellation" is checked. What would the formula be that when the cancellation box gets checked it would automatically fill in $25 into a "trip charge" column? Thanks!
-
Date
Hi! I have a tricky formula I'm trying to calculate, but with no success so far... I have to different sheets that I'm looking on. Sheet1: Planning and monitoring sheet Sheet2: Work reports The formula challenge: In Sheet2 our guys at the field are reporting on different predetermined projects. They report which date they…
