Time/Date Stamp formulas

K@te

Hi,

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

Find more posts tagged with

Formulas

Comments

Andrée Starå

Hi Kate,

Zapier is a great option for this scenario. Is that an option for you?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

K@te

I have not heard of Zapier. I am not sure my company would pick this up.

How would I incorporate that into Smartsheet?

K@te

Unfortunately, Zapier is not an option for me.

K@te

I have changed my submitted date column sot auto-number system created date.

that will give me a time/date stamp.

How would I create a formula that will add my working business days (not including holidays) based off of my priority levels, and the submitted date, to return the due date?

Ex Work week M-F Can not include holidays

Priority levels: High add 3 bus.days, Med add 5 bus.day, Low add 10 bus. days, Next biz day < 12 add 1 bus.day, Next Biz >12 add 2 bus.days

Then return due date.

Is this possible with the time date stamp (06/28/19 12:28 PM)

All help is appreciated.

K@te

Here is my Unparseable error.

=DATEONLY([Date Submitted]@row + 10),AND([Priority Level]@row="Low"))

=Dateonly[Date Submitted]@row+10) adds the way I need it to.

My problem is that I want it to add only if it meets "Low"=10 days, "Medium"=5 days, "High"= 3 days

This should inturn return the due date based on the criteria.

I am having a hard time writing the formula

I hope I have explained it clear enough.

K@te

Thank you for the help.

I did manage to get the formula to work myself.

Andrée Starå

Excellent!

Happy to help!

What formula did you end up with?

Sign in to join the conversation!

Quick Links

Trending discussions

How to delay the execution of a workflow whose trigger occurred much earlier?
I have a workflow that detects a row(date) that is changing its Fiscal Week Finish Date and send this row to other Sheet. Long story short: I collect delayed tasks in separate file & I tag reasons for delay for these tasks. It happens that plan are analyzed 2-3 hours and dates are being changed several times. I would like…
INDEX/COLLECT??
Having trouble with an INDEX/COLLECT/CONTAINS formula. I have two sheets, my source and my destination; the source sheet has a column I want to collect into the destination. -Tool ID, is in both sheets and the target of the INDEX/MATCH, the source sheet might have this listed 6 or 7 times -Purpose of Device, there are…
Netdays Formula
I am wanting to calculate Netdays but only if there is data in 'Corrective Action 1' I am currently using this formula: =IF(ISBLANK([Date Action 1 Complete]@row ), NETDAYS([Date of Event]@row , TODAY()), NETDAYS([Date of Event]@row , [Date Action 1 Complete]@row )) How do I adjust it to only pull a date when Corrective…