-
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…
-
Automatic weekly update
I am looking to have an automatically updated count for cases opened each week on a dashboard. Relevant data: - Date Consent Turned In To CBH] - [Member Goals] "Obtaining Consents" - I have a weekly identifier column [Week Consent Turned In To CBH] =WEEKNUMBER([Date Consent Turned In To CBH]@row) if that helps at all…
-
Formula error when trying to collect the next task due end date.
I am currently using the formula: =INDEX(COLLECT(Task:Task, Level:Level, 2, Status:Status, <>"Complete", Summary:Summary, 0), 1) to collect the next task due that is not completed for my summary section. I now want to collect the due date for that task. I have a column for "End Date" but not matter what formula I do, I…
-
Formula with multiple checkboxes and each has an associated comment
I have a form with multiple departments that are checked if they are affected. sometimes it might be one, sometimes it might be all (12 of them) or anywhere in between. If they are checked an update request is sent and they fill out a comment. I need another column (called Fully Reviewed) to be "No" until all departments…
-
Formula not working in some cells of column
I ran into an odd situation where the formula I am using is not working in some cells. I tried using this as a column formula (How I would prefer). I also tried it as a cell formula. But I have random rows where the formula simply refuses to work. This is the formula in question. It should fill in the Additional assignment…