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! 👍️
I created a template for a smartsheet because the previous owner no longer works for the company. I rearranged some of the columns and now the formulas are giving me this error. Can I clear the column formula and start over?
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…
