Time/Date Stamp formulas

edited 12/09/19 in Formulas and Functions


I am trying to auto populate a time date stamp when a cell is filled in on a row. Ex Submission Status

then I need to create a formula to populate a due date based on the time date stamp and based on Priority Levels

Priority Level  (Business Days)           

High - 3 days            

Medium - 5 days 

Low - 10 days 

NBD<12pm- (Next Business Day before 12pm )

2BD>12pm - (2 Business days after 12pm.)


I have attached a copy of my sheet to give you and idea of what I am trying to do. 

Any help is appreciated. 



Permit Drawing Submittal.PNG



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!