-
How can I use index-collect across two different sheets?
Hi everyone, I'm looking to create an index-collection formula that pulls data from two separate sheets, but I'm running into some issues. I have a 2024 calendar that lists confirmed projects, and the producer assigned to each project. I've also built a 2025 calendar with all the same data. I'm building a separate sheet…
-
Bring in data to new sheet
Below is a screenshot of the target sheet cell (Created on : etc) I want to update automatically when the source sheet is changed We currently have a cell link, but this is not updating without removing the cell link and redoing it each time. Here is the source sheet screenshot:
-
Pull dropdown menu options from one sheet into another based on a defined cell
Hello, I am curious if there is a way for Smartsheet to populate a designated column in one sheet with dropdown options from another sheet based on the conditions of a cell in the sheet the dropdown should appear in. For instance, if Sheet A has a specific value in the cell, you can pull in the dropdown menu from Sheet B…
-
How to track time off in Resource Management
I am trying to add our time off sheet to resource management. I went ahead and told resource management to add it as a project and changed the assigned resource column to employee email in the settings. However, I don't understand how to get to allocation to work with this? Once I set it up with RM, the allocation column…
-
Assistance Needed: JOIN and COLLECT Formula Returning Blank Values or Duplicates
This discussion was created from comments split from: INDEX MATCH on multiple value cell.
-
Multiple IF/Thens that impact a single cell.
I've tried 20 different formulas and none are doing what I need. I'm starting to wonder if this is even possible. Okay, I am trying to make the Two Crucial Time Status for Alice ISD act as follows: If any of the Two Crucial Times monitoring items with stop signs are checked under Items Being Assessed, and the Alice ISD…
-
Rolling metric data sheet for chart that is current month and last 13 months
I'm trying to setup a metric data sheet that will automatically roll (update) without constant manual intervention. I don't believe I'm doing this right. We have multiple different types of task and I'd like a count by month of each that are In Progress. I want to show this data in two charts on a dashboard: a bar graph of…
-
SUMIFS referencing another sheet
I'm trying to get a SUM of a column, including only rows that meet specific conditions. I want a SUM of "Launch Requests Range 2" if "launch requests range 1 includes the word "template" AND if Launch Request Range 3 is "52" AND if "launch requests range 4" (which is a date-type cell) is in the year 2024. I've tried…
-
% in formula issue
Good morning, I have a column which named "% Complete". The next column, I wrote: =IF([% Complete]@row = 100, "Complete", "Not Complete") That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's…
-
$1B in annualized recurring revenue - Learn more and join the celebration.
Hello Smartsheet Community, We’re proud to share that Smartsheet has achieved a milestone of $1B in annualized recurring revenue. Many of you have been with Smartsheet for many years, seeing the product expand and evolve. From modest beginnings, Smartsheet has pioneered the enterprise work management category – now working…
