-
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…
-
Auto checkbox problem
Hi, I am using these two formulas to auto check a box. =IF([Column Title1]@row = "Word", 1) =IF(ISDATE([Column Title2]@row),1) Both work individually, but i am having trouble nesting them and making them work together. I need the check box column formula to check for a word (single select dropdown) in one column and a date…
-
Date Formula
I have two quick questions; I need a formular to express the following: End date of column A = Start date for column B ( I tried setting the columns equal to each other but get an error) Second formula Column C = Column B +10 ( I tried Date1 +10 but get an error)
-
#invalid value error on a counting from previous year month
Hi good day everyone. I have a formula that was working fine until now January. The formula what is doing is counting all new items added in a sheet on previous month =COUNTIFS({What is it?}, "Risk", {Created date}, AND(IFERROR(MONTH(@cell), 0) = MONTH(DATE(YEAR(TODAY()), MONTH(TODAY(), 1) - 1), IFERROR(YEAR(@cell), 0 =…