-
How to concatenate multiple IF statements' texts
Hello! I'm new to Smartsheet. I have a sheet that used to be in an Excel file. There's a column call "Currently Delay (Rolled Up Reasons)" which I'm having trouble creating. The original Excel formula is: =IF(AU6="Yes", CONCATENATE( IF(AND(AE6<>"", AF6 > TODAY()), $AE$3 & " ","") , IF(AND(AG6<>"", AH6 > TODAY()) ,$AG$3 & "…
-
Formula for: %Complete to be automatically changed to 100% when Status is updated to Complete
Hello community! I'm looking for this formula: %Complete to be automatically changed to 100% when Status is updated to Complete _ and, I don't think I can put a formula in the %complete column so where would I put it??? Thanks!
-
Summary Count of Status by Assigned Person
I have been racking my brain for a bit to figure out a formula for a summary sheet that will give me a count of each status (not started, in progress, complete, at risk) by the user assigned. I am trying to pull this information from my project sheet. I have a summary count for each status but I cannot seem to add the…
-
Nesting If Statements and Dates
Hi, I am trying to create a status column that will populate a field with the parameters below: "Yes" if all of the cells in the row have "Yes" selected. "Late" if the today's date is greater than the due date and all of the cells in the row don't have "Yes" selected. Or else "No". I have tried several different formulas.…
-
How to count grandchildren rows?
Hi there! Can't count grandchildren rows. I did use COUNT (CHILDREN) in children rows and SUM(CHILDREN) in parent one. Everything I got, was 0 in parent row. Please see screenshot attached. Can you help me, please?
-
At Risk Formula
Hello! I am trying to put together a formula that flags a project 'at risk' when: Deadline is in 3 working days or les from today Status is not complete, on hold or canceled This is what I have - but my challenge is getting trying to incorporate 'workdays' to the formula. I've tried several ways and it is not working.…
-
Need help with formula using COUNTIFS and Contains
Hello, I am trying to use a formula that will count if a project type contains the word Planned and if the state (using symbols) is red. When I use the formula below, I get an "#INVALID DATA TYPE" error message. =COUNTIFS(AND({Audit&Advisory Services -Portfolio Metadat Range 1}, CONTAINS("Planned", @cell)), {Audit&Advisory…
-
Please correct Formula Examples - Contains Function
Here is a sample of a non-functional example. Technically this is a typo, and not a flaw in concept, but if the yield is zero then it is wrong irrespective of why. https://help.smartsheet.com/function/contains
-
Multiple choice Count
Hi. I have a question. I have a column name "Solution" and we have a dropdown multiselect option as column property with the following options: AVS Distributions Collections Others I want to make a count of each individual (that' is done and simple) but other if the column has multiple choices and count just as one. For…
-
Date formula not adding days
I'm trying to add "days" to a Date. The formula in the "Test" column is: =[Ex Works]@row + (IFERROR(INDEX({business days}, MATCH(Location@row, {location}, 0)), "")) This is the error that I'm getting. I'm not sure what I'm doing wrong.