-
Multiply
Hey, What is the smartsheet furmula for multiplying so far i tried =Skupaj ure za tekoči mesec1 * Urna postavka1 =[Skupaj ure za tekoči mesec]1*[Urna postavka]1 i am trying to multiply monthly hours and hourly rate..... no problem using excel.......
-
Automating RGYB Balls With Date Ranges
I want the status balls to automatically update based on the due date - but I also want the status to go blue after the "Item Completed" column is checked. Ie. If End Date is in the past, or due within the next week = Red If End Date is Due within the two weeks = Yellow If end Date is Due in three weeks or more = Green If…
-
Checking what Months are during a Project
Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budget and projected profits. I want to have an overview of how much money is allocated to each month and for that I need to…
-
SUM Function
I am trying to calculate Percentage Complete on a task (Project). I know the Percentage Left (that calculation is working perfect), but the Percentage Complete works on one sheet and not another. =SUM(1 - [Percentage Left]4) On the next sheet I try the same thing and all I get is the return of the function syntax. Any…
-
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:…