-
Formula Help with Symbols
I'm relatively new to Smartsheet formulas and I'm having trouble with the following formula I've tried creating to control the symbol displayed based on the Status selected for the row. Here's the formula I'm trying with the #UNPARSEABLE error received... =IF(ISBLANK([Status]8), "", IF([Status]8 = 'Ready for Testing',…
-
How can I use COUNTIF to find a total after a certain time
I am looking to count the amount of calls received after business hours from an exported sheet. In the below example, we received 6 calls after 5:00 PM, is there a way to calculate this? 07/15/20 4:54 PM 4079481564 Answered Linkcall 0 30 3 07/15/20 4:54 PM 6782966366 Answered Linkcall 167 607 414 07/15/20 4:56…
-
RYG balls & Dates
Hi All, I am working on constructing a formula that will automate based on the dates (Start Date, Due Date and Complete Date) I can get the balls to automate using one color or another but not all four within the same formula. I keep getting an unparseable or incorrect argument error. The below formula actually works…
-
Countifs and referencing another sheet
I'm attempting to use a countif using two criteria referencing another sheet. I want to see only the projects in "Entrance/Intake" that are in "House" SHRS. I'm getting the #UNPARSEABLE error. My Countif formula for only Entrance/Intake works perfectly. I need to slice this data by each "house" (VP) and I cannot figure out…
-
Calculate upcoming tasks
Hi, I am trying to calculate the number of upcoming tasks in the next 15 days. This formula works BUT the number returned is not correct. Any idea why? =COUNTIFS(Milestone:Milestone, CONTAINS("V2", @cell), [Published due date]:[Published due date], =TODAY(+15)) "V2" is in a text column with no other text in it I have tried…
-
Delay between two dates
Hello, I am looking to calculate the number of working days delay between two dates. I am using these formulas and getting an error (unparseble) =NETWORKDAY([Published due date]1, [Actual Date Finished]1) =NETWORKDAY([Published due date], [Actual Date Finished]) Suggestions?
-
Help needed - AVG(Collect).. - #divine by zero error
Hi, This is Ryan and help needed. I'd like to get an average value either project status with ''in progress'' or ''complete'' whichever data available but with below formula, it shows #divine by zero' error. When I try use only 1 condition either "in progress'" or "complete'', then it returns value. =AVG(COLLECT({OSAT…
-
Linking Summary Sheet Field Data Into an Existing Sheet to Report on Multiple Projects
Hello - I will be creating ~35 project plans for 35 customers. All will have the same set of tasks. Within each of those sheets, I will have the same (4) summary fields, that capture the following: milestone status, # of outstanding milestones, non-milestone status, and #of outstanding non-milestones. From there, I am…
-
Contact List Dropdown - Adding multiple contacts to the list at once
Is there a way to import contacts into a contact list column in a specific sheet? I know you can import a list of contacts to the SS account but I have 2,000+ contacts that need to be added as a dropdown in a specific sheet (a contact list column). I'm assuming there is no direct way to import the list into that specific…
-
Index(Match()): Lookup a price of a product from another sheet but keep historical entries
Hi am am hoping to lookup a price of a product from another sheet based however keeping historical price changes. Smartsheet A: We have production runs of product XYZ listed in a sheet A. Based on a concat we want to lookup a product price based on the MOST RECENT entry from Smartsheet B. However we want to keep Entry A of…