I hope I can describe this... I work for a video production company and I create individual projects for each video project we have going. There are general task descriptions I use in the Primary colu…
Hi, I want to create a RYG status if a date is late. If it is one workday late it is "Yellow", if it is 2 days late it is "Red" and all other are "Green". The End Date is the due date. The underlined …
I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1. Example: Cell A1 = "Sent w Statement" Ce…
Hi all, Trying to create a field that will tell me what percent of a list of values have exceeded 80%. =SUMIF([Goal Progress 2017-2018]3:[Goal Progress 2017-2018]7, ">80%", [80% Value Forumula Use]3:[…
I have several smartsheets that have formulas and conditional formatting. These smartsheets are pulled into a summary report. The formula's and conditonal formatting do not update when opening the rep…
I am trying to create an IF Function for Various Statuses (Not Started, Hold, Complete) - When selected, Drop Down changes to Gray ball for Not Started, Yellow ball for Hold, Red ball for complete
I am trying to craft a formula that sources a numerical value in a different column and, based on that value, prints a skill level. Here's the formula: =IF([Points]1 <99, IF([Points]1 <199, “Apprentic…
