-
Formula help within a Sheet
Hello - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tasks - if they are all "Completed" then the formula should say "Completed", if they all say "Not Started" then the formula…
-
How can I add a reference sheet to this formula - I have build another sheet that I want to add up
-
Formula
Hello All, I am trying to write a formula on a Status column. the conditions are: Not Started if planned start date is in the future and actual start date is blank. In Progress if actual start date is not blank and its not pasted planned start date Delayed if actual start date is blank and today's date is passed planned…
-
Only Part of my formula is not working and I can't figure out why
I created the formula below and it is working for the section that says "Validations - Issue Validations" and "Validations - Regulatory Issue" part and I can't figure out why =IF([Risk Activity]@row = "Control Testing", IF([Actual Cycle Time]@row <= 75, "Green", IF([Actual Cycle Time]@row <= 90, "Yellow", "Red")), IF([Risk…
-
Formula Help - Index/Match with Multiple Columns
I have two sheets that I'm trying to connect. I'm sure there is a simple solution, but I'm brain dead! SHEET 1: Course Grid - this sheet contains all session codes listed by date/time (columns) and Room names (rows) SHEET 2: Course List - this sheet has all the information about each session (1 session per row). I want to…
-
Index/Match using dropdown with multiple selections
Hi, I'm trying to use Index/Match to list the mission statement(s) for each selected non-profit from a dropdown that allows multiple selection. The mission statement lives on a reference sheet and I'm able to get the mission statement if only one non- profit is selected but not when multiple is selected. I thought I found…
-
Formula to Determine Numeric and Non-Numeric Values
Hi all, I am trying to combine a formula converting a numeric value to a specific format with a check for non-numeric values so the non-numeric values are passed through and don't cause an error. I was able to account for specific non-numeric values however, we have some variability I need to account for. Formula for…
-
Pls Help! Automating Rollover of dates Based on change of a status
Hi Everyone, Can't seem to find much information on this topic can anyone help with the below? Or point me in the right direction. Trying to create an annual calendar with deadlines. The calendar includes Monthly, Quarterly & Annual Deadlines. The idea is that when a team member changes the Tracker column to "Completed":…
-
How to get the average of symbol type (stars) column?
Hi! I'm a virtual assistant new to Smartsheet and I was tasked to replicate a skills assessment worksheet template. It uses the symbol (stars) ratings so I can get the average score and the number of skills that were rated using the stars. For the average stars, I tried to use the same formulas in the template but Lookup1…
-
Formula - Order of Operations excel to smartsheets
Hello, I am trying to get this math equation to work in smartsheet that normally working in excel and can't figure out how to do the proper order of operations. Can anyone help? AN2 is the cell in excel I am pulling the number 15 into. Formula should = 0.06 =((AN2/86587))*30*1000/(90) =([2025 Total]@row/86587))*30*1000/(90)