-
Can index+match be used to add values together?
I'm in the process of creating a series of sheets to track weights submitted by a variety of people. The people are going to be categorized by 'team', and I already have an index+match formula that takes their submissions and automatically organizes them to like a main row per person, each value going into the column for…
-
Is it possible to add a new line in a Formula?
I found this discussion from 3 years ago: https://community.smartsheet.com/discussion/adding-carriage-returnline-feed-calculated-text It got a response from the community manager, so I would like to assume 3 years later it was implemented at some point Is there a way I can do this?
-
So i want to know how can i sum up purchase requests based on dates
I know how to do it with COUNTIF({2023 dates }, AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023)) How do I change this to add the SUM of purchase requests that only falls in quarter 1 of this year, and i can then do it for Q2, Q3, Q4
-
DATEONLY as a column formula
Hi, Is there a way this formula could be modified with @cell so that it could be converted to a column formula? I can't convert this formula to a column formula as it references a specific cell. =DATEONLY(Created77) Thanks, John
-
Help - Trying to Write Simple % Calculation Formula
Hello everyone! I'm trying to write formulas to help create visibility into a department's KPIs, which will eventually feed into a Dashboard. I'm fairly new to writing Smartsheet formulas and have been struggling. I need to reference 2 main columns (Role M1 Actual & Role M1 Goal) in my formula to deposit the result in a…
-
SUMIFS with Working Days
Hello, I have the following formula that works but I want to adjust it to working days only: =SUMIFS({Column1}, {Date}, <TODAY(), {Date}, >TODAY(-90), {DE}, ([Column2]@row)) Is there a way to modify this formula to include only working days? I think that the sheet is counting weekends at this moment. I updated the…
-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Help with a formula
I am trying to use the IF formula and I can't figure out where I am going wrong. Thanks in advance I need to subtract the Contract Amt from the budget amount ONLY if Financial responsibility is TI or Make Ready. So if the financial responsibility says Landlord, I don't want the contract amt to be subtracted from the budget…
-
Formula to bring back value of a cell based on month
Hello! I need help figuring out a formula and possibly on how to set up a helper sheet to get the formula to work: I currently have a capacity plan for our team. My leaders would like a widget on the dashboard that will just show the team members' names and their allocation for the current month. So I need help figured out…
-
"Rollup" column type
In planning budgets, I need to roll up costs into something like this: I can put the formula sum(children()) into the rollup field, but I have to do it manually and I have to do it for all of the parent and grandparent fields. I can't make it a column formula because then I can't enter the values for the children. It would…
