-
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…
-
vlookup issue and multiple selections
I'm using a form to collect headcount changes at locations we manage. I'm using a vlookup to autofill the site managers name based on the site location chosen. However, I've run into an issue when the person filling out the form selects more than one location (selected via drop down multi-select list). If the headcount…
-
Issues with Automations on Calculated Fields
I have a task tracker for our team that I want to auto-archive tasks 5 days after they are complete. I built a checkbox column that compares the completed date to todays date (using a reference rather than TODAY() formula so the formula works when I'm not in the sheet) and if it's been 5 days it checks the box - which in…
-
Is there a way for <search-value> in the MATCH function to be ANY non-blank value?
I'd like to be able to search a column to find ANY first non-blank value not just the one corresponding to the first argument in the MATCH function. A wild card basically for <search_value>.
-
Using INDEX MATCH Function with a Multi-Select drop-down column
Hello, I am trying to use an INDEX MATCH function to fill in the Transmission Region for the Sites Under Consideration, but am running into a problem when there is more than one site selected. I believe I need to add the HAS function, but have tried several ways and can't seem to make it work. Any help is appreciated!
