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'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
