-
Progress Status / Health Automation
Good morning everyone, I'm new to Smartsheets and have been really enjoying the functionalities and automations. I'm trying to set up an automated Health / Progress status and keep getting a "#UNPARSEABLE" error. I've looked through my code and can't figure it out.... Can someone take a look and help me see what I'm…
-
COMPLEX INDEX/MATCH arguments issue: Project Updates Tasklist
@Paul Newcome @Paul Newcome I need your expertise My manager has tasked me with referencing data from a hierarchy of rows, for multiple columns, but wanting the Parent Row to be updated from the inputs of the data in the CHILDREN rows, which he then is asking for the most recent update of that selected customer. I am…
-
COUNTIF formula
I'm trying to figure out a formula to count the amount in the Budget column cell if the Actuals column cell is blank. Thoughts?
-
IF/ OR
Hello, I am trying to create a formula that encompasses multiple dates. The current formula I have is as follows: =IF($[In Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type In]5, IF($[Out Date]5 = ($[In Date]$4 + [03-OCT]$4), $[Day Type Out]5, IF(AND($[In Date]5 < ($[In Date]$4 + [03-OCT]$4), $[Out Date]5 > ($[In Date]$4 +…
-
Moving DATA from source sheet into new sheet that has formulas that need to be applied to new data
Hi, I have developed a new sheet (NEW PROJECT SCHEDULE) for our PM's to use that has a lot of formulas in it, on almost every row (Parent and Child rows) as well as Summary formulas for a Dashboard. This prototype has tested and worked well for new Projects because the original data is being copied to the NEW PROJECT…
-
Index and Match for multiselect column?
Hi all, I'm a little stumped on this one. I am trying to extract the selection(s) people are noting in a multi-select column in another sheet. I set up a marker in both sheets to I can use that as the indicator on where I can line up the Match formula but I get a #INVALID DATA error. Is there something simple I'm missing?…
-
Current year streak and rolling unbroken streak formula help
I have a dashboard metric that I could use help with. I have a Consistency Club to recognize associates that achieve their monthly sales activity metrics, measured by individual month. Meaning if they have achieved their metrics for Jan, Feb, Mar, Apr, May and June their current year consistency streak would be 6. If the…
-
Is there a formula to calculate the overall state of a specific group of projects in a metadata?
Hi Smartsheet Community, I am trying to calculate the total number of green, yellow and red projects I have on a sheet based on different project groupings. My goal is to be able to have a chart in the dashboard that would report on the overall state of a group of projects based on their location or strategic initiative.…
-
Formula regarding Checkbox Column
Hello Smartsheet community, I'm attempting to write a formula for a project plan type grid sheet. One of the columns is a checkbox to represent when the item is complete. I'd like to write a formula that counts all the checked activities to get management a % complete value based on how many boxes are checked and the…
-
Row ID (ignoring blank cells)
I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks entries. (Row ID) I hope somebody is able to help