-
Work Flow "Unable to Run"
Hi all. I've built a number of sheets with multiple work flows. On this sheet, for the first time, i've experienced this error message. When i open the sheet, i don't see any indication of what is causing the error. I've rebuilt the work flow and the associated DocuSign Template multiple times and i get the same result.…
-
Using an IF formula for Parents, Children rows
Hi all, I'm currently trying to see if there's a formula that can be used to affect the parent row (row above the indented row) after a certain condition has been met within the children row (indented rows). Please see the image as a reference. In this example I've set up, I'm trying to figure out if there's a formula that…
-
How do you SKIP a BLANK cell when using an INDEX / MATCH formula?
This is a working formula to pull values from another sheet. The issue is that on the SOURCE sheet, when the "PCN" is blank, they are showing a default text under the "Enrollment - PCN" column. That works perfectly for the SOURCE sheet, but is messing the automations on MY (destination) sheet. =IFERROR(INDEX({Projected…
-
I'm trying to use INDEX/COLLECT to bring back more then one result in the same box
I'm using INDEX/COLLECT =INDEX(COLLECT({TMPIT}, {TM}, Login@row, {TMPIT}, ="Dock Stocker"), 1) This works for 1 result. If a login has more then one result, how do I get those result all in one box? example I want to search the list and see that awhit has all of these machines I would like the result to be Also if the…
-
Formula to work with different levels of Hierarchies
Hi, I'm currently trying to figure out a formula that would help with collecting results from a certain column and only when those results are all "true", can the Child row (of the same column) be marked as "true" (without affecting other parent/child/grandchild rows of the same column). Here is an image of what I'm trying…
-
IF AND Formula referencing another sheet
I have about 250 locations that need to submit a monthly report. I need to show which locations have and have not submitted their report for each month, and a need a year tracking. I have a SUBMISSION sheet where their submissions populate. They select the month for which they are submitting from a dropdown. I have a…
-
Formula help
Hello all, I have the formula below. I also want it to bring in another STATUS besides "Initial in Process" ... I also want it to find anything with "Ready for Credentialing". Can I just put a comma in after Initial in process and add that in Quotes? =IF(COUNTIFS([Individual NPI #]:[Individual NPI #], [Individual NPI…
-
Trying to return the date if a certain row task is marked Complete
After spending some time learning about a bunch of different things in Smartsheet that aren't helping with my problem, I thought I should just ask my question. I am missing something small I think. I have tasks in my projects that need to be completed after it is implemented. I want to capture the "Execution Complete" task…
-
Project Milestones Metric Help
Hi, I'm a newbie SmartSheet Admin for my organization and am still trying to get my head around some of the ins and outs of the tool, so apologies if this is a basic question! At my organization, one of the core metrics we're supposed to report on is the number of project milestones completed within +/- 4 weeks of the…
-
Help with formula for line chart?
Right now I have a formula set up to count hours for each week given certain criteria. The count from each week is then added to the past week to get an ascending total each week to display in a line graph for a running total. How can I write this formula to count when it is the current work week only so that the chart…