Sign in to join the conversation:
Hello!
I'm trying to trigger the flag in the overdue column if we've missed the proposed response date. My formula is calculating, but it's not turning the flag on. What am I doing wrong?
=IF([PROPOSED RESPONSE DATE]2 < TODAY(), "1")
Try Removing the quotes from around the "1".
=IF([PROPOSED RESPONSE DATE]2 < TODAY(), 1)
Okay, I figured out the flag part. However, now it's immediately flagging if a date hasn't been entered yet. Here's the formula that I'm using. . .
=IF(TODAY() > [PROPOSED RESPONSE DATE]@row, 1, 0)
Please help! Thank you!!!
That's because blank date fields are considered less than any entered date (nothing is less than something kind of thing). We can use an AND statement to include the criteria of it being an actual date.
=IF(AND(ISDATE([PROPOSED RESPONSE DATE]@row), TODAY() > [PROPOSED RESPONSE DATE]@row), 1, 0)
Perfect! Thank you!!
Happy to help! 👍️
Hey Smartsheet Guru’s I have 2 sheets – 1 is capacity and the other is ooto – Sheet 1 – capacity has names and emails and %the first 3 columns and subsequent columns has week to week start date(as text), end date as text and number of days excluding holidays In the OOTO file – it is a simple if someone requests timeoff it…
I have a sheet and I want the checkbox option to appear as checked if the cell in the name column of the same row is one of 133 options- is this possible in a single formula?
Hi there, since yesterday I have noticed that the Sheet Name column links in reports are not taking the user the correct row in the source sheet, as they have always done. There does not seem to be a pattern, sometimes it takes the report user to the top of the source sheet, or to a random row, or the odd time to the…
