-
COUNTIFS a start date is less than today, and is an ancestor level 3
I am currently struggling with the following COUNTIFS formula =COUNTIFS(AND([Start Date]:[Start Date], <= TODAY(), ISDATE([Start Date]:[Start Date]), [% Complete]:[% Complete] <= 0.5, [Helper Column]:[Helper Column] = 3)) It should read as follows... Count a row if it... has a Start Date that is less than or equal to today…
-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…
-
Getting status of a RYG with a Date Column
Greetings, Thank you for taking the time to read this. I am a newbie to both programming functions and to Smartsheet. I am working on a sheet where I require to report out the RYG Balls on the end of calendar months. I have two columns I need to create a function for- "Date of Update" and "Status Report." When the Status…
-
Translating Date Formats
We have Smartsheet integrated with another system and pulling data across into Smartsheet. Currently the date format that is coming across is (YYYY-MM-DD) and I want to translate that into my local profile date format of (MM/DD/YY). Is there a function or formula that allows me to do this? I have been unsuccessful in my…
-
If Statement for three columns
Hi Guys! I am working on the following Formula: =IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = "", Correction1 = ""), "Overdue", "OK") Goal: If the date in a date column [Date Completed] is more than 3 days ago, and the cells for the next two columns are empty - one or both - I want to remind our technicians to fill…
-
if statement
Hi, Can someone help me on this formula. Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No.
-
If Status is "Completed" then make % Complete "100%"
I need help with the formula to automatically make the % Complete be 100% for any row where Status is "Completed" Do I put the formula in the % Complete cell? And if so, what formula? What I have tried so far does not work: =IF(Status=Completed,%Complete=100%) That's probably wrong for a variety of reasons, but I can't…
-
I need help using multiple functions, if statements and parent/child.
I have 3 columns that have information; Scene, Take and Revision. The scene can be broken into sub-scene and sub-sub-scene etc... This column will always have a value. Columns Take and Revision may or may not have a value. I would like to add a fourth row called Full Name. This column will combine the information. I was…
-
Exclusion Formula for Sum/Count
I am trying to get a total of my "Forecasted Amount" column which should include the following stages "0-Lead"+"2 - Qualified"+"3 - Proposal"+ "4 - Final (EL)"+"5 - Win". Currenly I have it set up to only not include the "6 - Lost" with this formula: =SUMIFS(CHILDREN([Forecasted Amount]52), CHILDREN([Referral…
-
Reference a column in another sheet
Hello - My company is new to smartsheets but it has ALREADY made a huge difference for us. I'm playing with functions that reference other sheets and I have a very specific question - I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same. The formula I'm working looks…