-
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…
-
How to show cell hierarchy values
Is there a way to show the values of cell hierarchy no matter the amount of parent/child? In this example (see screenshot) I would like to output: 121b1a Thanks
-
#UNPARSEABLE
I cannot get this formula to work. Any suggestions? =IF([% Complete]1=0%,"Not Started",IF([% Complete]1=100%,"Completed","In Progress"))
-
Formula to determine the date that another cell was updated
Hello, Looking for some formula help. I am using the formula below and need to figure out how to display the date the Status cell was changed instead of updating to today's date. =IF([Status]1 = "Completed", TODAY()) Thanks for your help! Andrea
