-
How to change Overall Health column from text to stoplight symbols
I have a formula in my Overall Health column that is based on the Status column. Green=Complete, Yellow=In Progress, etc. After multiple attempts I have a formula that seems to work but instead of getting the stoplight colors, I am getting the text instead, "Green" instead of the green dot. I assumed this was an issue with…
-
SUMIFS won't work, count doesn't match column count
I have a SUMIF formula, where I am counting the sum of percents if the Stage equals certain stages (1-5) =SUMIFS({Stage Percent}, {Stage}, [Status]@row) Inexplicably, today, the formula broke and is giving a "INCORRECT ARGUMENT SET" error message. The EA Stage Percent is fine, because when I remove the Stage and Status @…
-
Calculating Schedule Health - RYBG
Hello, I am a beginner Smartsheet user and I have listed my set of requirement to track my schedule health task. The requirements are based off % Complete and % Time Elapsed. Requirements below: Tasks that show status of “Complete” - Blue Status in progress, where the % Complete is greater than or equal to Time elapsed. -…
-
Compare Text
Is there a formula that I can use to compare the amount of similar words between two cells? I have two columns that have similar text but sometimes there is a period or comma that throws of my MATCH formula. Thanks, Miles
-
AVG COLLECT giving #UNPARSEABLE
I thought I applied a formula I saw on here (thank you Paul Newsome) to my situation but am getting an #UNPARSEABLE error with this formula: =AVG(COLLECT(([Discovery/Planning Time]:[ Discovery/Planning Time], [IT Functional Team Owner]:[ IT Functional Team Owner], "Data Analytics & BI")) I'm want the average of…
-
How to count up a number of distinct values.
I have a list of what we call "opportunities" (opps), and some are linked to a specific project name (i.e. there are a number of opps for multiple Customers, but all being worked on at the same time under one project). I need to be able to count up how many opportunities we have but also how many distinct projects we have…
-
SUMIF matching rows and columns from another sheet?
I’m trying to create a resourcing table where for various projects, we complete how much time they will work on a project in the coming weeks. This is not a timeline or Gantt chart, so it doesn’t have dates, but it does have a list of all the projects and the hours are distributed over the weeks of the work. Instead it has…
-
Custom Auto-Populate Row ID with different references
I am needing to create a Change Order (CO) sheet for one project but has more than one company with change orders. I am looking to see how I can auto populate each row with a change order # that references each company. Example: Project X Three companies: A, B, C. For Company A, I would like each CO line item to be…
-
formula
Help, can get my formula to work with one set of cells but not another =DATE(YEAR(TODAY()), MONTH(DOB@row), DAY(DOB@row)) - works fine =DATE(YEAR(TODAY()), MONTH(Start Date@row), DAY(Start Date@row)) - wont work #unparseable error Why, what am i doing wrong
-
Count the same content of a cell on several sheets
Hello everyone, I am trying to count the number of cells in about 40 sheets in which "SLF-FP-001 Commercial" appears in a "Green" status. Is-it possible ? I know how to do it for a single sheet: =SUM((COUNTIFS({Sheet 1 Range 1}; "SLF-FP-001 Commercial"; {Sheet 1 Range 2}; "Green"))) Thank you very much for your help.