-
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…
-
Formula Help
HI, I need a formula for the screenshot below that looks at if 2022 Show Start Date is less than 90 days out and Rebook Plan in Place column is unchecked, assign the status column as "Red" and if checked then the status is "Green".
-
Countif the Month/Year matches the current Month/Year?
Current formula displayed at bottom. It counts the amount of Values in Range 1 that are created in the last 30 days. The formula works, however I'd like to change the second countifs statement, in particular the Today(-30) so that it matches the month/year of the date. That way, it will track the Values in Range 1 created…
-
cross sheet formula with multi-select range?
ive got a database of resources with various teams and departments people are on. in some cases there is multiple teams someone is on. How can i use HAS or CONTAINS with a cross sheet index/match?