-
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…
-
Record changes to only 1 cell
In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record who changed which phase. I know that I'm able to right-click a cell to see its history,…
-
Do links/formulas update in the background without opening the sheet?
Ive built a project management system in SCC and have setup everyone to work from reports. If all goes well no one would ever go into a sheet. If no one goes into the sheets ever, would the formulas and cell links and conditional formatting, etc update still? or do these require someone to enter a sheet (not a report) and…
-
If/And Statement
Hey again, I am stuck with something a bit beyond my current skills. I need to write a formula that I believe will be an If/And Formula. The formula needs to populate the Case Status cell. If the the Tentative Return Date column is blank, the Case Status Cell should be "N/A", if the Tentative Return Date is within 10 Days…
-
How to I "not format" a number in a form?
One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even though I typed it as 2016, 2017, 2018. The only way around it is to direct people to…
-
Help setting up formula IF
Hi there, I'm trying to set up an IF formula to pull the Month from the "due date" row. I've been using the following formula: IF(MONTH(DATE@row) = 1, "January", IF(MONTH(DATE@row) = 2, "February"....) Although we have a cut off date which is the 25th of every month. All projects due after this date should be pushed to the…
-
Change symbol based on date
Good morning Everyone, I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which... Green appears if the last run date is within 30 days Yellow appears if last run is within 31-60 days…
-
Formula that will allow a date in text format to be captured in a date format
I have a Date getting imported as 08JUN2021 (2charDay+3charMonth+4charYear) and I need to switch it to a Date format that will allow integration in other formulas and logic flows. So far I have tried these 2 formulas without success: =DATE(VALUE(RIGHT([WES Evaluable Report Date]@row, 4)), VALUE(VLOOKUP(MID([WES Evaluable…