-
Nested Formulas
Hi, I am counting the number of days in a calendar month, my formula works until I get to August. Am I missing something or is there a limit on how formulas I can nest? Thanks Here's my nested formula… =IF(AND([Property Related Tasks?]@row = "Yes", [Log Month]@row = "January"), "31", IF(AND([Property Related Tasks?]@row =…
-
#INVALID OPERATION Caused By Data Import Adding an Apostrophe
I have a Nintex Automation Workflow set up in which users fill in a form with numerical data and submit it - the form is basically an end of day inventory count. The form pre-fills all fields to 0s, and users can change the totals if there is more than 0 of any item. Smartsheet doesn't like data importing with blank cells…
-
How to extract substring from a cell between certain characters in smartsheet
Here I have multiple hyphens(-) but i want to only extract the text between the left most hyphen and right most hyphen For eg: Email-Apple-banana-mango-No Response is the string and I want to extract Apple-banana-mango
-
MAX(COLLECT multiple values
The sheet I am working on keeps track of the most recent dates that an item is requested. One of these items have 2 different item codes, but they are an equivalent item. Let's say Item1 and Item2 are different names, but if either is requested, it counts for the same thing. The current formula to return one value is…
-
#BLOCKED Error with COUNTIFS when Range columns are populated via equations
Hi, I am trying to calculate the amount of "Used Inventory" by counting the number of times "Block Date" appears between "DATE 1" and "DATE 9" but am getting the #BLOCKED error. Columns "DATE 1" through "DATE 9" are populated by equations based on "CheckIn Date" and "CheckOut Date." Below, you can see the columns in use…
-
How to Generate - Unique value using Index formula in the Columns Instead of Rows
Fruits_Master_List S. No Fruits Index Apple 1 Apple Mango 2 Mango Pineapple 3 Pineapple Cherry 4 Cherry Mango Pineapple Cherry Pineapple Apple Mango '=IFERROR((INDEX(DISTINCT(COLLECT({Fruits_Master_List}, {Fruits_Master_List}, @cell <> "")), [S.No]@row)), "") I am using the above-mentioned formula - to generate the fruits…
-
How to count 1 incident type with multiple scenarios based on ticket open days?
Hello Smartsheet Community, I have an IT incident report sheet created (shown in the attached picture) and a separate IT Ticket Metrics created. In my IT ticket Metrics, I would like to count how many P0 tasks under priority has a ticket status with "Not Started", or "In Progress", or "With Customer", or "Returned" that…
-
RAG Status
Hello! Newbie here :) I was wondering if someone could help with a formula I'm attempting to put together to calculate a RAG symbol status for individual tasks as well as the overall project plan. Individual Tasks: If status is complete = blue If status is in progress OR not started AND end date is today = yellow If status…
-
Sum Formula for Adding Values
I am trying to create a formula where it is looking at a column with a dropdown where multiple options can be selected and assigning a value to each option that may be selected. I thought that I had the formula set up correctly but keep getting the error #UNPARSEABLE. Can someone help me understand what I might be doing…
-
How are you automating S-curve graph in Smartsheet?
I understand that Smartsheet does not currently have an in-built S-curve capability. Has anyone been successful to create a more automated S-curve graph since the project trackers is already capturing the dates and progress?