-
Reference another sheet to return quantities from multiple rows
Hi all - I am building sheets with corresponding forms to allow individuals to receive and distribute supplies across several locations. What I need: a master inventory sheet reference other sheets, specifically for an item name and the quantities received. The quantities received will have multiple continuous entries…
-
Sum of hours from various cells and subsequent calc of FTE based on certain criteria
Hello, I would like to ask for help. I've got a sheet that can automatically calculate the FTEs of people assigned to projects but I need a little tweaking. There is a current layout: Currently, the FTEs are calculated based on what region is the global lead and that takes into account the "Lead MM - MDR Oversight Hours"…
-
Cell Link or Formula for Start and Finish Dates
I'm looking to find a solution to populate the start and finish date columns based on info in another sheet. However, because I have dependancies turned on the date columns cannot use a vlookup or other function to pull the dates from another sheet where they are stored. Here is the basic setup: Grid 1 includes dates…
-
Date column formula to start on a specific date and continue on after that.
Hello, So I have a helper sheet that tracks total number of entries for each month in each year. Right now I have a formula set up that checks the date above, and depending on if the current month is past that month, it will automatically fill in a new line with the current month (Due to date formatting, I have it set that…
-
Ranking Formula
Hello all, I have a sheet with columns that look like this: Spot in Queue Case Number Case Prep Completed Case Completed 1 100 x 2 101 x 3 102 Essentially, what I would like to do is change the spot in the queue when the case is completed. For example, when I check off 'Case Completed' for case number 100, the spot in the…
-
Calculation of 2 types of different hours in a single row
Hello all, So I've got this formula that automatically breaks down budgeted hours into individual cells based on Start and Finish Date and Total budgeted. Now I'd like to add another set to this formula that will calculate different hours and break them down too. The circled ones are already being calculated and the yellow…
-
Formula to shift numbers in a column
I have a column called "Priority" that has my tasks (rows) ranked by importance, with 1 being the top priority and 10 being the lowest priority. When I check off a task I want to delete 1 from the most important task and have that 1 replace that task that is numbered "2". Is there a formula to do this? Something like if 1…
-
IF then statement
Hi, Fairly new to smartsheet, I am looking to do the following: If 'Drop Down A' is set to 'No', then set 'Date Column B' = 'Date Column A + 30' If 'Drop Down A' is set to 'No', then set 'Date Column D' = 'Date Column A + 14' If 'Drop Down A' is set to 'No', then set 'Date Column E' = 'Date Column A + 7' Appreciate the…
-
IF/AND cross-sheet formula not working
Hi all, I'm trying to create a column formula but only select one date out of 2 available. Current layout of my sheet is as below: What I'm trying to teach to the system is that if Global lead is not equal to X and Regional Start-Up Date (green) is " ", then use "Lead Start- Up Date", else use "Regional Start-Up date....".…
-
Smartsheet causes CPU usage spikes
I'm using Smartsheet in Google Chrome and notice that when it's left open for a period of time, Chrome is using a lot of CPU resource, to the point that the mouse won't move smoothly across the screen and typing is delayed appearing on screen. I don't think my Smartsheets are particularly complicated - the biggest is…