-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Mod function substitute
I am creating a due date field that will auto update for a Dashboard. The goal is that every 2 weeks an updated date will be shown. From what I can see MOD is not supported in Smartsheets. I am wondering if someone is able to help me with a mod substitute on a date field like I have done in Excel. The formula in Excel is…
-
Work Column
Hi all - I'm trying to add a "work" column similar to that of Microsoft project. Specifically, I'd like the work of the child tasks to roll up to the parent tasks: Parent task 1 (3 - Sum of child tasks) - Child task 1 (1 hour) - Child task 2 (1 hour) - Child task 3 (1 hour) Is there a way to do this?
-
CountIF between 2 dates and Notblank cells
Hello community! First post here I need to count the number of cells in a separate column per month. Example: March: 13 April: 10 Ok, what I've already tried: =COUNTIFS((Criado:Criado); @cell = DATE(2018; 3)) Returns: 0 counts Expected: 20 counts =COUNTIFS([Título da ideia]:[Título da ideia]; NOT(ISBLANK(@cell))) Returns:…
-
Automated RYG Balls
Greetings Smartsheet Community! I am working on a formula to automate the RYG balls in a status column that references data in the cells of 3 columns, and it seems to be working well. I am wondering if there is a way to add to the formula so that the status column stays blank until the data in the reference cells is…
-
CountIf Help
Is there a formula that would count the number of cells where a Done check is not completed but only when another columns due date is in the past? The goal is to count how many past due tasks I have. Does anyone know the best way to accomplish this?
-
SUMIF Trouble
I am trying to use SUMIF to add the dollar amount for jobs that have 100% probability. I wrote this formula: =SUMIF(Probability:Probability, "100%", [Quoted Amount]:[Quoted Amount]) and it returns a 0 but no error. Also all of the data in this sheet is linked from another sheet. Is the problem because the data is linked?
-
Help on Formula: automate status based on dates
Hi all, I'm pretty new with formulas and I wanted to automate the status of each projects based on dates. I have columns Status and Progress. The status column have a selection of: Completed, Active and Not Started and the progress column have: On-time, Delayed and Not Due. On the screenshot below, the columns Status and…
-
Formula driven by date
Hi All: I only want this formula to activate only if it is greater than or equally to today's date, but having trouble adding TODAY part of the formula: =IF([% Complete (Actual)]3 > [% Complete (Planned)]3, "Up", IF([% Complete (Planned)]3 > [% Complete (Actual)]3, "Down", IF([% Complete (Planned)]3 = [% Complete…
-
COUNTIFS Formula Help
As one of the pieces of logic in a formula I'm attempting, I want a count within a range (column) if the date (formatted as MM/DD/YY) falls within the year 2017. What do I need to change in the formula as shown in my screen shot?
