-
Formula help - reference data from 2nd sheet, with conditions
Hi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if: Sheet 1 Date matches Sheet 2 Date, AND Sheet 2…
-
Is there an easier way to automate multiple columns from a single multi-select dropdown?
One of my teams uses a sheet to track to the status of products in every state, with a column containing a status dropdown list for each state (Requested, In Progress, On Hold, Completed, etc.). We recently implemented a form for our internal clients to submit requests. As part of this form, we have two questions…
-
Connect several columns from data sheet to another sheet
I have searched all over for this and have seen several references to VLOOKUP and INDEX/MATCH. From what I have been able to gather is those functions are using some type of extra reference to work. I have a large data sheet with a lot of columns. I am trying to copy the data from a few specific columns into another sheet…
-
How do I set up a workflow to notify someone if a predecessor task has been completed?
I am currently trying to develop a project plan sheet, and I am wanting to be able to notify someone when the predecessor task was completed so they know they can start working. For example if John has to do a Data Source Identification and validation but he can't do it till Mark has converted and cleaned up the data I…
-
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…
