-
Keeping a running balance
Hi I have a simple sheet that I am using to track bursary payments. Each time we make a payment I want the column with the total budget left to decrease based on the amount that we have given as a bursary. How can I do that? I tried =SUM(100000 - Cost@row) but all this is doing for each row is taking away that row amountโฆ
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
What formula if I have two variables
Hoping someone can help me with this one. I need a formula to show totals by GEO and booked/non booked. If the Sales Order Number is blanked, it's not booked and i want a total by GEO for pipeline. If the Sales Order Number is non-blank, then I want a total by GEO for booked. When I'm done, i want on a seperate sheet:โฆ
-
How to combine multiple rows of data into one row based off of one cell value.
Hello Smartsheet's community! I am back with another question. I have a database that holds the tracking of employee trainings. The training structure is in tiers and after each completed tier they fill out a form. The raw data from this forms looks like this: Depending on an employee's level they will have a differingโฆ
-
Cross-sheet formulas can't be updated
Hi all, We have a sheet that references a lot of data on other sheets using index and match functions. Recently, we began receiving the below notice and many cells in the sheet come up as "#calculating." What do you propose as a workaround to this issue? Thank you in advance
-
If Formula Help
Hello all, I created a requisition form with collumns to allocate products to 3 different locations and 7 departments inside of 1 of those 3 locations. Each location and department has a corresponding code. Our main location, "EHT" is 1-7 and the other two locations are 8 & 9. The formula I'm using to allocate products byโฆ
-
Formula to automate a dashboard and reference previous / next cell
Hi, I am trying to build a formula to remove a manual step in a report. I'd need some guidance on how to do. In the screenshot below, I want to automate the % of change calculation. % of change = last week SLO - this week SLO. I think I can use the "Used in Dashboard?" column to build a formula but not really sure how toโฆ
-
Copy Pasting from one sheet to other
Hello, When we try copying/pasting from a source sheet to a destination sheet, the conditional formatting is not being carried over. Anyone else facing this issue? Thank you, Neha Kaushal
-
Countifs Formula is returning the incorrect Amount.
I am using these three countifs formulas referencing multiple columns in another sheet and it is returning with the incorrect results. What I am doing wrong? =COUNTIFS({TE Team}, "PME", {Status}, "Active", {Health}, "Green") =COUNTIFS({TE Team}, "PME", {Status}, "Active", {Health}, "Yellow") =COUNTIFS({TE Team}, "PME",โฆ
-
Sumif across sheets using criteria
=SUMIFS({New product Load sku}, {New Product- Prime Tab}, [Primary Column]@row, {New Load- Stage}, OR(@cell <> "Ops Team Reviewing", @cell <> "Working", @cell <> "Assign to Data Team", @cell <> "Data Team Rejected", @cell <> "Ops Team Missing Info Request Sent", @cell <> "DT Reviewed - Ready To Assign", @cell <> "With PM",โฆ