IF, THEN formula that references a checkbox field and a date field
I'm trying to write an IF, THEN formula that references a checkbox field and a date field, but I keep getting errors. Here's the logic: If the 'EMDS' column is checked, then calculate the 'Date Needed' column minus five days. If seems simple, but it may actually be too complicated for the system since it essentially involves nesting formulas. Here's what I have so far, which is returning an #INVALID COLUMN error: =IF(EMDS@row = 1, [Date Needed]@row  5,). Any advice is appreciated.
Best Answer

=IF([EMDS]@row, [Date Needed]@row  5)
The column that contains the formula must be a "Date" column.
Answers

=IF([EMDS]@row, [Date Needed]@row  5)
The column that contains the formula must be a "Date" column.

Fantastic. It originally was a Date column, but I kept getting the 'Date Expected' error message so I changed it to a Text column. I changed it back to a Date column and now it works exactly as intended. Thanks!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 63.6K Get Help
 403 Global Discussions
 215 Industry Talk
 454 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 56 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 296 Events
 36 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!