-
How to rank highest to lowest
I would like to rank a range where the #1 rank is the lowest number in a range. The formula I am using ranks the highest number as #1 =RANKEQ([Revenue Per Year]1, [Revenue Per Year]:[Revenue Per Year], 1)
-
Merging Lines from 2 or 3 smartsheets to one smartsheet
Hi, Actually i have several forms that I am sending to be completed by my clients. However, I would like to put all the informations obtained in only one smartsheet. I would like to migrate the informations from theree smartsheets in only one, thank you in advance for your help.
-
I need to make this formula more compact/ fit into a cell. Any Ideas??
=COUNTIFS({[Orange] Service Support KPI - [2022: Q2] Range 1}, [ABC Name:]@row, {[Orange] Service Support KPI - [2022: Q2] Range 3}, @cell = "NEWS - Pull/Send", {[Orange] Service Support KPI - [2022: Q2] Range 4}, AND(@cell >= TODAY(-8), @cell <= TODAY())) + COUNTIFS({[Orange] Service Support KPI - [2022: Q1] Range 1},…
-
help with my Sumif formula when criteria in another column matches
Hello SS Community, I would like to sum a range of sells if it matches the criteria in another cell. Overview- I want the total of all Approved Quotes, Placeholder, Quotes Received. This is the formula I used and it is UNPARSEABLE =SUMIF([Estimated Total (Before tax and shipping)]8:[Estimated Total (Before tax and…
-
Multiple Approval and levels of Escalation
I seem to be running into a brick wall. I am trying to set up an approval process that can have multiple tiers. I have a worksheet that assigns someone based on the territory. All the while I am needing to track on the worksheet where the approval is currently... Territory: CA, WA, AZ = Bill Jones, ID, NV OR = Bob Smith;…
-
Trying to place dates in monthly billing columns based on Award Start Date - Desperate for help!
Hello All, I am in desperate need of assistance, this project is making me crazy. I admit to being more comfortable in Excel, and I always think I can do things in Smartsheet that I can do in Excel until I find out I can't. I would normally use VBA to do this, and am having trouble getting a cell formula to work. Currently…
-
Formulas for auto creating start time / end time based on duration - Event Runsheet
Hi, I am wanting to create an event runsheet. I have a formula that automatically calculates the duration from start time / End Time but Im having trouble figuring out how to automatically calculate Start Time / End Time from Duration which is more Ideal. I could enter a Start Time & End Time in the parent row and then in…
-
How to get distinct values from "Host Manager Name" and "Active Contractors"?
I am trying to consolidate the "Host Manager Name" column to state the name once in the "Distinct Name" column. I would like the same for the "Active Contractors" column, to state the number once in the Max Number Column. I followed the instructions from the link below: It worked for the first row, but as I dragged the…
-
INDEX and MAX gets Invalid data type match
I have the reference to the MAX working correctly and pulls the newest date, but when I add it to the index to pull the information from the text field in the associate sheet I get invalid data type. Am I missing something? Can you advise? =INDEX({Display by Tech Range 2}, MAX({Display by Tech Range 1}), 0) Display by Tech…
-
Forecast Formula
I am trying to figure out a formula for the following from a reference sheet: {Value Column} = SUM total {Date Column} = current YEAR, specific MONTH {Primary Column} = CONTAINS "Invoice" in Children to MATCH "Client Name" in Parent {Status Column} = "Forecast" ISBLANK if none of above match or cell is empty