-
VLOOKUP on the if false of another VLOOKUP
I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID" and return the "User" If they exist in one of the 5 reference sheets. This is my current…
-
Multi dropdown on report
Hi, I'm trying to do a report which shows things from a multi drop down list; in this case, quarters. The projects can run over multiple quarters and I want them to be showing in each of the quarter. I have created grouping with the quarters too but it won't show the data when in multi dropdown, only when it is a single…
-
Using a range of checkboxes for an IF statement
Hi, I have a column of checkboxes, and next to them are cells with just regular text. I want the text to be referenced in another sheet only if the checkbox is checked: I can get it to work for just one value fine with =IF({checkbox reference}, {personal goal reference}), however this is just one pair of cells and I would…
-
Iterative Functionality (circular reference) in smartsheet.
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools. The specific situation is that I want to track how long a card…
-
Is it possible to query the URL's of sheets to table?
Hi there, I am trying to update some references on a roll up sheet and would like to quickly get the URL's of some key project artifacts. I'm not sure if there's a SQL type function in Smartsheet that would let me quickly let me get this data across all our workspaces. For example, I'd like to find all my Project Budget's…
-
How to record monthly changes in sheet?
So I am trying to get a formula to return a count of the number of cells that match but only if another column that records a date is within the last 30 days. I tried with reports but the issue is they don't display right if I try to send updates in any way besides a link (and I need it to run monthly, weekly, etc.) I felt…
-
Workaround for Voting
Hello, From other community questions I see that there is no voting functionality in Smartsheet but I am looking for a workaround. The use case is to have a system for internal enhancement requests to our ERP. Internal employees would have a link to a dashboard where they could look at requests that have already been…
-
Unlink sheets
Hi, I have a folder with several documents (reports, project plans, etc.) and they are all linked to various different sheets in different workspaces. I accidently saved the folder as new, but I selected "Original Sheets". Is there a way for me to unlink the new folder from the original folder, without having to go into…
-
Index & Collect Using Date Range
Hello, I'm trying to return cell values from another sheet based on a date range in a date field but I can't seem to get the formula to work. In a new sheet, I want to return the value of a specific cell from a different sheet based on the date range (3 months prior to today) field. This is what I tried and it doesn't seem…
-
Countifs with Row Reference
Hello I have about 100 lines of Primary data in a column that will reference another sheet that I am summarizing. I am trying to create a COUNTIFS formula that will use the Row Reference for the Primary Column to count column data from the other sheet and allow me to copy the formula down. My formula is fairly simple…