-
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?
-
Count If and Not blank
Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria. The columns are: Responsible Department - I want to count the cells in this column that are not blank and Program Name - Here is the Criteria - I want to count the cells in the…
-
Risk Status- Grey, Red, Yellow, Green Bubble Formula
I'm not sure why my formula isn't working. I also wonder if I can do Today(-7) in the formula. I've seen +days but not -days so maybe that's the issue? If so, how do I write it such that if the finish date is within the next 7 days, the bubble will be yellow? Here's the formula: =IF(status@row = "Not Started",…
-
Count Netdays if Project Status is "Complete"
Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date", and "Actual End Date" I have a grid with 200+ projects/rows (Project Intake Sheet), and would like the formula to…