-
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)
-
Is there a way to have a formula output into a text string?
QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a sheet with a form that collects meeting infromation, agenda, and atteendees required so that the PM's can schedule them…
-
ISBLANK AND formula issue
Hi Community: If a task has gone unassigned for >=5 days after initial entry has occurred AND the task has not been assigned to someone, I need to flag the concern and workflow route to a specific individual. Column A: Intention for IF this column is BLANK (fyi Properties of this column is dropdown list) AND Column B has…
-
Project Status Formula Help
I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column Hierarchy=0. The objective of the formula is as follows: If the Project Override field (in the Sheet Summary) is filled out…
-
"#invalid column value" Error in Sheet Summary
Hello all, I would like to retrieve the date of "LR1" with the following Index Match function (see field 18). Once I hit enter I receive the error message "#invalid column value". Is something wrong with my formular?: =INDEX(Finish:Finish, MATCH([Field 16]#, [Task Name]:[Task Name], 0)) Many thanks in advance for any help…