-
RYG formula not working
I have been researching formulas trying to find solutions without having to tap into the community and duplicate my question with others, however, I really am stuck. Trying to create a formula for RYG based on planned finish date and status. Here is what I wrote - unparsable is the error. Are there supposed to be spaces…
-
SUMIFS formula
=SUMIFS({Completed date}, MONTH(@cell) = [Jan 2018]$1, {S/S}, AND({Rep} = "Paul")) Hi All, Trying to get the above formula to work. Referencing from another sheet. Want to be able to match a sales reps figures per month. From these columns in the other sheet: Completed date column, Invoice value column and rep column. So…
-
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…
