-
How To Identify Max Value
Hello, Need help, I want to identify which questions have the highest "No" respond. On column "MAX - NO" will appear the name of the questions that have the highest No respond. Currently, I can identify the maximum of respond on each questions. I don't know which suitable formula to combined with MAX to capture which…
-
How do you extract numbers out of a cell and create a chart with the data
How do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time" and then on possible another sheet show a chart of over a period of time. I was even thinking, I could…
-
RYGB BAlls with B = empty cell
I have a basic formula I can't get to return a B ball when there is an empty cell. =IF(Count@row = 0, "Green", IF(Count@row > 0, "Red", IF(Count@row = "", "Blue")))
-
How to drag formula and prevent cells linking together reference sheets?
When I enter a formula (e.g countif) that references another sheet, and then drag this formula to the next rows and try to change the sheet referenced, it changes all the cells as if the formula is linked between all the cells. How do I replicate a formula I want to be in multiple rows but then edit each row to reference a…
-
CountIFs (Time and Blanks)
We use Smartsheet to provide customers with an invoice and allow them to give us a PO. I am wanting to create a formula that will count invoice past 90, 60, 30 days that have a blank in the PO #. I am pretty sure I have FINALLY figured out the date function, but can't figure out how to "marry" it with the blank function. I…
-
COUNTIFS nested formula help
I'm trying to get a count for multiple solutions but am getting the '#NESTED CRITERIA' error. =COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement", @cell) + COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement - 2nd Solution", @cell))) Essentially I need it to give me…
-
Move select column data to new row
I have a Smartsheet form that allows employees to request up to 5 unique dates and times (to come on campus). For these dates and times, I have columns: Date1, Time1, Date2, Time2, etc. Ideally, I'd like to have one column of date and one column of time so that I can pull a report on a daily basis for our access point…
-
Template Package and Metrics/Dashboard Chart
Hello, I'm using the Project Management Office Template set and trying to change the Portfolio Metrics' Project By Status column with new stages. However, I'm not sure how the formula is calculated in the screenshot. I'd like to link to the Dashboard to create a bar chart (see mockup) of the number of projects each in…
-
Update TODAY function
This discussion was created from comments split from: Smartsheet Function - TODAY().
-
Health Color Bubbles Tied to % Completion & Dates
Hellow, I am trying to take the following plan with the follow formula to follow these rules and am stuck. Disclaiming not the best at the large multi conditional formulas yet. I use the Health Column bubbles RYGB If a task has 0 % Complete and is not past Start Date, green or no health ball if possible If a task has > 0 -…