-
Ranking Prices by Name - Need Formula Help
Hi, So I can't seem to figure this out. Below I have the name of a manufacturer with how much we are spending with them in no particular order. I'd like to use a formula that tells me, in decending order, the top 10 manufacturers we've spent the most money on. I would need the information to be listed like below STERIS…
-
How do I get my report to pull in ALL "modified by" transactions across multiple sheets?
I currently have a report where i am checking to see when an individual checks a box between a given time frame. I have set up parameters to look for a specefic user and i have selected all the sheets i want to pull the data for but it still seems to be missing transactions when i spot check across the sheets they are…
-
How can I optimize/accelerate data parsing across sheets?
I have a robust sheet that stores the raw data in smartsheets that is then pulled into multiple formulas across different sheets. As the raw data file gets extensive, the sheets and dashboards linked to it have started so slow quite a bit (not updating up to 20 minutes after data input into the raw data file). So I've…
-
Sorting Conversations/Comments
Is there any way to sort the conversations/comments by newest to oldest as opposed to how it seems to be, oldest to newest, as if there are many comments then it can take a while to scrol?=l? Appreciate any feedback FYI - I already have the 'Latest Comment' column activated, but its for all other comments
-
NETWORKDAYS between a date and a number
How does it work to minus a number of days from a date cell using networkdays? One column is a Due Date that I would like to populate based on a set date that will be static in [Due Date]9 cell I put in the Due Date column =[Due Date]9 - 180 (works fine, and gives me the result of a date based on the cell [Due Date]9 minus…
-
Trying to pull data within a date range - need assistance with the formula
I'm attempting to collect data across sheets and am having a hard time getting my formula right. I want to collect the number of sites in a program that falls into a particular date range. So, I want to pull from our intake sheet all sites in Program A that are due between 1/9/23 and 1/13/23. I've tried a couple of…
-
Column Properties using Symbols
Anyone here used the 6-state Pain Scale in their sheets/dashboards? We plan on using this for our customer satisfaction survey and I want to know how you guys came up with the formula. If there's an article available around this might be helpful too. Best, Grace
-
Capture Last Modified Before It's Modified Again
Hi. I'm trying to figure out how to capture the last modified by and last modified date at a specific time (trigger) before it's modified again by something else. Currently, I have a main sheet and a "helper" sheet. On the main sheet, where all the action happens, when someone selects "Approved", I have a formula-ed column…
-
Please can you help me getting a IF(AND Formula working
Hi, I have the below calculation, it all works apart from the part in Bold, if I show a number between 13 and 20 I get a #INCORRECT ARGUMENT error. any help will be greatly recieved. =IF(["Score Probability x Impact"]@row < 7, "Low", IF(AND(["Score Probability x Impact"]@row > 7, ["Score Probability x Impact"]@row < 13),…
-
Average If formula to calculate if multiple criteria is met
Trying to create a formula that will average the # of days based on the contract manager name & if the dates are for the month of June. This is the formula I'm using which works until I add the date range in. The data is in 2 different sheets. =AVERAGEIF({CM SLA (received to opened) Range 1}, [Contract Manager]@row, {CM…
