-
Creating a Cash Flow Model
Dear Developer I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies. The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers…
-
Attempting to use SumIfs where 1 column could have multiple different values.
Hello! I have tried to find the answer by browsing through questions already submitted about sumifs but I can't seem to find a question that addresses my issue. Apologies if this has been asked and answered. I'm attempting to sum a column based on the values in 2 other columns. my column headers are: Sprint, Task Hours,…
-
count decision formula
Hi all I have a sheet that using the decision symbols, can anyone help me with the formula that counts the number of Yes, No, Hold. I would be happy if there was a way of just counting the number of the green yes Many thanks
-
SUMIF Between Sheets
Can smart sheets handle a sumif across different sheets? I want to do something like this.... In sheet B: SUMIF (range in sheet A, where the task is the same as task in sheet A, add all the hours in sheet A) - should return total hours where tasks are the same. This is difficult to describe - please advise! :)
-
Sumif help
Hi, I am trying to show a rolling 6 months resource allocation matrix, so that I am able to include the resource allocation figure on the dashboard and need some help with the formula that will be required. Tried the formula in the snap shot, but it does not seem to work =SUMIFS([Resource Duration]7:[Resource Duration]23),…
-
Building Sheet to Alert Past Due Items
Hi All, I am trying to build a sheet that will track when items are turned in to our billing department. If the "turned in"date is past a certain date then I would like for the sheet to send a notification to certain people. The only thing is the "turned in" cell will remain blank until the date it is actually received. Is…
-
Netdays - if blank
Hello all -- I have created a column to show me how many days between "today" and the expected close date of a sale. This is the formula I'm using: =NETDAYS(TODAY(), Close Date16) This is working, but I have one problem: I don't always have an expected close date. In those situations, I want the cell to display as blank.…
-
Time Between Dates, dependant on status of another column
Hi, Hopefully I can get this to make sense. We have a spreadsheet that has a Date Reported Column and classification column (classifications being - near miss, incident, injury) with a formula column. Is there a way to create a formula in the formula column that has the number of days between today and the latest date in…
-
Problem saving a large sheet when insert/remove/move rows.
I have a large Smartsheet with 1472 rows, 30 columns and about 27,200 cells with formulas, mainly IF() functions plus three simple conditional formatting rules. The page will load in a few seconds and simple changes save in a few seconds but if I insert or delete a row near the top of the sheet, or move some rows from near…
-
Pending Report - Formula Assistance Needed
Y'all... I struggle with formulas. Please help! On our sales tracking sheet, we track probability of the sale closing, expected close date, and the price low and price high of each potential sale. I'm currently using a modified version of the Sales Pipelne with Summary template. In addition to the summary (that shows…
