-
IF AND "unparseable" - desparation
Hi, If have no other ideas any more - maybe some fresh eyes could help me? There's something in there it doesn't like Thanks a lot Katja IF([1. Tax Class]@row = "Duty paid", "very low" If 1. Tax Class@row = “bonded” and 3. Volume flag@row = “no”, then “low risk” If 1. TaxClass@row = “bonded” und 3. Volume flag@row = “yes”,…
-
Project Health for Next 60 Days
Can someone please help me create a formula to indicate the health of a project via Green, Yellow, and Red spheres for activities in the next 60 days? Currently, I have the health of the project shown on the dashboard for all activities over the duration of the project.
-
If statement and Networkdays function problem
Hi, I's struggling with a rather simple problem, but thereäs just something wrong with my logic/syntax. Here's the formula, which gives "Unparseable" for me :/ =if([PK]@row = "Siivous", NETWORKDAYS(MIN(Start4:Start13); MAX(Finish4:Finish13))), "") If there's "Siivous" as the value for a dropdown cell in the PK column, the…
-
Counting blank rows in the denominator as nested formula
Hello, I have the following formula which is working well: =IFERROR((((COUNTIF(Status:Status, "Green")) + (COUNTIF(Status:Status, "Yellow"))) / ((COUNTIF(Status:Status, "Red")) + (COUNTIF(Status:Status, "Green") + (COUNTIF(Status:Status, "Yellow"))))), "") I need to also COUNTIF the rows are blank under the 'Status' column…
-
Lead Time calculation
Hi I am trying to create a lead time calculation to see when a request for work was submitted vs what the due date is. Purpose to report on lead time to promote better planning. I had this working when I had a request date in my form. However I subsequently changed that field to a "created date" system field to auto…
-
How to use IF statement formula
Hi Smartsheet Community, I currently need help in generating a formula where in I have multiple countries in a dropdown column and I need to identify which region they are from. Ex: A form collects data from users and they input their country. In the back end (grid), I need to collate all entries per region. So Country…
-
Formulas to set up KPI's for shipments requests
Hi, I need some help with forumals which is not my strength, thanks in advance. What I need is to set up KPI’s measure for my shipments. There are 3 parties involved that need to complete their own step. Once each step is completed by each party (regulatory, WHS and Logistics). it will record a date highlighted in the…
-
Unparsable IF( & Gantt
I'm trying to make my Gantt display carry my current projects out with a hidden "completion date" row and IF= code, but it won't work. If my unhidden completion date cell is blank, I want it to autofill todays date so my gantt will show current projects, but if my viewable completion cell has a date in it, I want it to…
-
Is there a formula I can use to count how many points someone has received?
We are using smartsheet for submissions for a point-based program we are running. When someone submits an item to the smartsheet through a form, they are awarded between 1-6 points based on what the item is that they submitted. Is there a formula I can use to count how many points someone has received so far, based on the…
-
Profit formula
Sorry for the basic question. I need a row that calculates profit. I have a row titled COGS and a row titled Sold Price and a row titled Profit/Loss. What and how do I add a formula to the Profit/loss row that would calculate that for me? I am SO GRATEFUL for any help! I tried this formula =Sold Price@row - COGS@row and…