Auto Checkbox Formula - past the date
Hello, I'd like to have some kind of formula for the checkbox for it to be checked once the date is passed...meaning the meeting has been completed. That way we don't have to manually do it and probably forget to do it. What kind of formula would I use?
Best Answer
-
There should be a comma before the 1.
Answers
-
Try this:
=IF(TODAY()> [SQV Date]@row, 1)
-
Hii thanks for answering! I'm getting an error message on it :( any thoughts?
-
There should be a comma before the 1.
-
Yay it worked thank you!
-
Happy to help. 👍️
-
@Paul Newcome how can I add to this equation to not mark lines that are blank in the date column as late?
-
@Liz Wallace You would start it with another if.
=IF([Date Column]@row <> "", rest_of_original_formula)
-
@Paul Newcome this is what I am trying and its not working =IF([Due Date]@row<>,(TODAY() > [End Date]@row, 1)
-
This was my current column formula" =IF(TODAY() > [End Date]@row, 1)
-
@Liz Wallace Your syntax is off. You are missing the double quotes before the first comma and the IF before the opening parenthesis before TODAY().
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!