If and when..


The thought process is a have a column with Multiple drop downs. If Service is selcted I would like it to take the date column and add a six month date for followup. The formula I was thinking is:

=IF([What work type was completed?]@row, ="service", Date@row + 180, blank)

However, I must be missing something. UNPARSEABLE lol🤔

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!