Calculate Working days with Multiple If Conditions

I have a scenario to calculate due dates with the following logic.

LOW - Greater than - 7 days

MEDIUM - Greater than - 4 days

HIGH - Greater than - 2 days

CRITICAL - Greater than - 1 day

I have written the formula like this

example - Low 7 days -

Request Created On - 04/01/2024 will achieve the output date as 04/07/2024. But I need to calculate the working days or weekdays.

=IF(Severity@row = "Low", [Request Created On]@row + 7, IF(Severity@row = "Medium", [Request Created On]@row + 4, IF(Severity@row = "High", [Request Created On]@row + 2, IF(Severity@row = "Critical", [Request Created On]@row + 1))))

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!