Adding Days to Date but Days Column Includes Text

I'm trying to calculate the end-date for a purchase order.

Columns used in the formula are Start Date, Contract Max Length (Days), and I'm adding an additional 60 to cover a Net 60 payment cycle.

The "Contract Max Length (Days)" column includes a Data Verified text option in the MS Form collecting the data.

I was able to use IFERROR to calculate the total price and it worked: =IFERROR((([Bill Rate]@row * 10) * [Contract Max Length (in days)]@row), ([Bill Rate]@row))

When I use the same IFERROR formula to parenthetically add the values ([Bill Rate]@row + [Contract Max Length (in days)]@row +60), the text is "added" to the date. It doesn't cause an error, but it doesn't create a date. Ex. "10/31/22Direct Hire60"

Any advice on this one?

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Are you able to provide some screenshots for context?

ChrisGyurnek

Screenshot for assistance

Christian G.

I would use "isnumber".

=if(isnumber([Contract Max Lenght (in days)]@row),[Start Date]@row+[Contract Max Lenght (in days)]@row+60,[Start Date]@row+60)

Paul Newcome

You will need to use a basic IF statement. I would suggest something like this:

=[Start Date]@row + IF(ISNUMBER([Contract Max Length (in days)]@row), [Contract Max Length (in days)]@row, 60)

In Smartsheet you can concatenate text/number/other data formats together into a string using "+". So Smartsheet thinks that you are just wanting to add the text string on to the value in the start date column. Since that is not technically an error, the IFERROR will not actually trigger.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.