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 th…
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.
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 trie…
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…
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 …
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 …
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
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 = "Comp…
I am logging man hours for construction jobs. I have three columns that perform this function. One column for "Budgeted Hours", one for "Actual Hours" and one for "Remaining Hours". I input hours into…