Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.

Check writing integration?

Loann McGee
Loann McGee ✭✭✭✭✭✭
edited 12/09/19 inArchived 2015 Posts

下午好,

Is there a 3rd party entity that is able to pull data from invoice/payroll data to then print checks for employees/vendors?

Blessings,

Loann

Comments

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    I can see how you could do thi if the accounting package is API friendly and so use such as Zappier to populate your Smartsheet row, then Merge to Google Template for writing the checks, but we would have to know more about your system to run a test.

    Hope That Helps

    RichardR

  • Loann McGee
    Loann McGee ✭✭✭✭✭✭

    I'm asking on behalf of someone who owns an excavation company and is looking for an easy-to-use software to track bids, jobs, inventory, invoicing, payroll and checkwriting. I think Smartsheet will do all but the latter, so I thought I'd check (pun!) for input on the community.

    Open to recommendations!

    Blessings,

    Loann

  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    We work with lots of construction companies that have similar needs Loann and so your requirements list looks quite achievable in Smartsheet, probably easiest to achieve if they are a "Google House" as they can use the Merge to Google feature for Quotes & Invoices the rest is good content for Smartsheet use.

    Good luck

    RichardR

  • Loann McGee
    Loann McGee ✭✭✭✭✭✭

    Thanks, Richard. I've passed the info along and hopefully it gains interest and they can come on board!

  • Nic Mangialardi
    edited 07/01/15

    Hello Loann,

    Building off of what Richard stated previously, there are some great third party integration platforms that can link your information from SmartSheet to various other APIs. One easy to use integration platform is Azuqua, for whom I work. Information can be integrated through the use of what we call FLOs. Through a simple drag and drop system, users can link SmartSheet to various other applications like Acumatica, Salesforce, Concur and others which can organize and track your data. There are plenty of functions that users can access which will manipulate and organize the data and then transfer the information to other applications to store. You can check it out herehttp://www.azuqua.com/ andtry a 14-day free trial to see if this platform is a good fit.

  • Loann McGee
    Loann McGee ✭✭✭✭✭✭

    Thank you, Nic. This would be for a family-owned business, and once we start talking API's and such, it's beyond their realm.

    However, I hope to be able (if they choose to go with Smartsheet) to go them to help get them set up. Maybe then I can help them navigate through these options - though API's are above my understanding at this point, too.

    Blind leading the blind! ;-)

This discussion has been closed.
If you want to know the percentage over\/under the Contract Amount<\/strong>, your formula (placed the [Percentage] column) would be:<\/p>

=([Contract amount]@row - [Install Labor (actual)]@row) \/ [Contract amount]@row<\/p>

Be sure the \"Percentage\" column is formatted as a percentage. Positive numbers show that your total spend is under<\/strong> the [Contract amount]. Negative values show your total spend is over<\/strong>.<\/p>

You can use a similar formula to measure how far over\/under your [Labor $ (quoted)] amount is from your [Install Labor (actual)] amount.<\/p>

=([Labor $ (quoted)]@row - [Install Labor (actual)]@row) \/ [Labor $ (quoted)]@row<\/p>

Here, though, a negative value shows that you are OVER<\/strong> the estimate. A positive value shows you are at or UNDER<\/strong> the estimate.<\/p>

\n
\n \n \"Screenshot<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":107038,"type":"question","name":"Modified Date loses detail when referenced","excerpt":"Application: Trying to capture and display a 'sheet last modified' value on a dashboard. Approach: Using a formula in the sheet summary sidebar to find the max value of all timestamps in the 'Modified' column. Formula is as follows and is functioning as expected. =MAX([Modified]:[Modified]) Problem: The displayed value…","snippet":"Application: Trying to capture and display a 'sheet last modified' value on a dashboard. Approach: Using a formula in the sheet summary sidebar to find the max value of all…","categoryID":322,"dateInserted":"2023-06-28T17:43:23+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T21:44:02+00:00","insertUserID":154049,"insertUser":{"userID":154049,"name":"Rob W.","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20W.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T21:44:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":154049,"lastUser":{"userID":154049,"name":"Rob W.","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20W.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T21:44:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":25,"score":null,"hot":3375964045,"url":"https:\/\/community.smartsheet.com\/discussion\/107038\/modified-date-loses-detail-when-referenced","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107038\/modified-date-loses-detail-when-referenced","format":"Rich","lastPost":{"discussionID":107038,"commentID":382970,"name":"Re: Modified Date loses detail when referenced","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382970#Comment_382970","dateInserted":"2023-06-28T21:44:02+00:00","insertUserID":154049,"insertUser":{"userID":154049,"name":"Rob W.","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20W.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T21:44:18+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T21:29:15+00:00","dateAnswered":"2023-06-28T18:46:15+00:00","acceptedAnswers":[{"commentID":382932,"body":"

Set the Sheet Summary field as text\/number then add +\"//www.santa-greenland.com/community/discussion/502/\" to the end of the MAX function (plus quote quote) to convert it into a text string.<\/p>

=MAX([Modified]:[Modified]) + \"//www.santa-greenland.com/community/discussion/502/\"<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":107037,"type":"question","name":"date range formula","excerpt":"Hi dear community, I need a formula to return the values \"Process\" and \"At Risk\" when a certain date is reached. I have a \"Start date\" column. I need to notify the assignee of the status for each task (all in separate columns). When we are 145-91 days from the start date, it should return \"Process\". When we are 90-0 days…","snippet":"Hi dear community, I need a formula to return the values \"Process\" and \"At Risk\" when a certain date is reached. I have a \"Start date\" column. I need to notify the assignee of the…","categoryID":322,"dateInserted":"2023-06-28T17:30:38+00:00","dateUpdated":"2023-06-28T17:36:27+00:00","dateLastComment":"2023-06-28T21:09:58+00:00","insertUserID":162910,"insertUser":{"userID":162910,"name":"Haleh","url":"https:\/\/community.smartsheet.com\/profile\/Haleh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T21:03:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":162910,"lastUser":{"userID":162910,"name":"Haleh","url":"https:\/\/community.smartsheet.com\/profile\/Haleh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T21:03:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":21,"score":null,"hot":3375961236,"url":"https:\/\/community.smartsheet.com\/discussion\/107037\/date-range-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107037\/date-range-formula","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107037,"commentID":382966,"name":"Re: date range formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382966#Comment_382966","dateInserted":"2023-06-28T21:09:58+00:00","insertUserID":162910,"insertUser":{"userID":162910,"name":"Haleh","url":"https:\/\/community.smartsheet.com\/profile\/Haleh","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-28T21:03:14+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-29T10:21:48+00:00","dateAnswered":"2023-06-28T18:44:53+00:00","acceptedAnswers":[{"commentID":382931,"body":"

Try this:<\/p>

=IF([Start Date]@row>= TODAY(-90), \"At Risk\", IF([Start Date]@row>= TODAY(-145), \"Process\"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending Posts