-
How do we get our hyperlinks to work properly?
We are currently working on a sheet where if a specific number is entered in a cell, a corresponding hyperlink will be next to it. We have a sheet for hyperlinks and the IDs that are associated with them so that we can use a formula to pull that link when it sees its code. Our issue is that even though our links are…
-
Sum If
I'm trying to do a sumif calculation that returns the dollar amount that was overpaid. I already did a simple formula of =[Open Balance Amount]@row - [Amount Paid ]@row. I wanted to know if its possible to show as a plus amount vs negative(-) amount
-
From another sheet, how can i lookup / pull a list of values ?
Hello world, I have two data sheets that both have columns that contain a identifier for what the row references. I want to make a list in my third sheet that contains all the identifier values of these two data sheets that meet my criteria of containing letters xx in the end of their identifier names. Is this possible?…
-
Having Formula Troubles
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
-
How do I list projects from a specific department across multiple cells?
I have a Smartsheet where one sheet contains a list of projects categorized by departments. Each department has multiple projects listed under it. I need to extract and display all projects from a specific department in another sheet, with each project listed in its own cell vertically down the column. I've tried using…
-
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…
-
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…
-
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…
-
Adding two columns together for a total sum
Hello, I want to add a formula to third column (highlighted) that will add "# Dock Doors" and "# Trailer Parking Slips Onsite" together and it to total in the "Total Trailer Locations Onsite"
-
Split contacts to multiple columns.
In my sheet, I have multiple contacts in one cell. I would like to AUTOMATICALLY spread these contacts across multiple columns in the same row, so that each column has one single contact. The reason I want this is to send approval requests to each contact. (Currently, I can only send approval requests to all the approvers…