-
Countifs with Multiple Criteria in the Same Range
I am trying to create a formula to count the number of projects assigned to one person based on the phase of a project. My criteria is that is NOT one of the following phases: Construction, Completed, Punch, On Hold. I know I need to use <> to create the "not equal to" but for some reason, I am missing something to make it…
-
automate RYG balls
I'm a smartsheet newbie and i'm ultimately trying to build a formula that automates task progress based on the following: If % Complete = 100, return Blue If it’s not scheduled to start yet, return Clear If it’s past the scheduled finish date, return Red If % complete >= (today date-start date)/task duration, return Green…
-
Formula Help
Hi All, I am in need of some formula help! 1. I would like to count all of the projects in my portfolio that are in the Active state and either Yellow or Red health. I have a Dropdown List column for State and a Symbols column for Health (RYGB balls). This is the formula I've have been trying. I am getting the Unparseable…
-
Cross sheet formula - Reporting by week
Hi Again! Is it possible to create data that provides QTY of selections checked per week and record this on a sheet automatically with formula. So we are managing live installation projects, with a high turnover of projects. Our main sheet is called PROJECT MILESTONES where we track all the live project activity. Within…
-
COUNTIFS or other appropriate formula
Hi, I'm attempting to create a count of the occurrences of text in a column called 'DOCTOR' from a list of drop downs in rows 2 to 32 inclusive: FULL DROPDOWN LIST: CLINIC 1 CLINIC 2 CLINIC 3 NOT ROSTERED ON COMPANY BUSINESS UNPAID SICK DAY UNAVAILABLE I'd like to get an automated count of the instances of the following:…
-
Card view is deleting my formula
I've created formulas to automatically calculate status based on start/end dates and % complete. If you switch to card view and move things within this view it deletes my formulas. How can i lock users from card view or what are my options here.
-
Auto Filling a cell from data in another samrtsheet
Good afternoon I am creating a bid invitation sheet and need to list GC bidders per each job (row). * How do I create an autofill for these cells based on a directory I have created? * and once the GC is selected in this cell how do I autofill the column next to it with one of their many estimators at their company that is…
-
Formulas per column
Hello, Smartsheet team: If I select a cell containing a formula, I know I can drag the little box in the right-hand corner downwards to apply the formula to more cells of the column. Unfortunately, I need to do this for 300,000 rows! Is there a shortcut that will apply a formula to the entire column, or to a selected part…
-
Status and % Complete co-dependency formula
Hi there, I am trying to figure out how to get Smartsheet to automatically change "status" column to "Completed" when I enter 100% in the "Complete" column, as well as to "Started" when I enter any % higher than 0%, and to "Not Started" if the % is 0. Is there a way to do this? Thanks!
-
Formula needed that will generate quantity in one column against date in another column = how much a
I have the following columns and need to return the value of something from a date through the end of the year. 1. Est Mo Contract Count - A number 2. Ave admin - Dollar Amount 3. Estimated Value - 1 x 2 4. Start Date - Start Date that 1 actually goes into effect 5. Weighted Value - Sum of 4 through end of the current year…