IF formatting combined with a calculation

I am trying to include a calculation only if a certain qualitative value is met.

Trying to have the column indicate "Days Over Deadline" by subtracting the "Submission Deadline from the Submission Date," but only if the "Assessment Stage" is Issued.

=IF([Assessment Stage]@row)="Issued", =SUM([Submission Date]@row) - ([Vendor Submission Deadline]@row)

What can I do to make this formula work better?

Ideally, I would also like to freeze that number when the stage is updated and no longer "issued"--is that possible?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!