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.

Creating a Cash Flow Model

SuperGroup
SuperGroup ✭
inArchived 2017 Posts

Dear Developer

I would like to know if someone would be able to help me out (on a chargeable basis) to create a cashflow report that requires the consolidated view from 15 different companies.

The idea is that each company has its expenses, incomes, has starting bank balances, different bank accounts, suppliers, customers etc. I would like to know the net cash flow on a daily basis so that we can plan further capital spending.

There are recurring payments and recurring incomes that need to be entered and a consolidated view generated.

We will discuss in detail if someone wishes to take up the assignment.

Please let me know or get in touch via whats app : +96895242515 or hangouts on[email protected]

Neeraj Kalwani

Tags:
· Share on Facebook Share on Twitter

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Neeraj,

    I'd happily work with you and help you with setting up a Cash Flow Model.

    I'm based in Europe/Sweden so it will be remotely if that works for you.

    Have a fantastic weekend!

    Best regards

    Andrée

    (I'll also send you an email with my details)

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    https://workbold.com/

    Andrée Starå| Workflow Consultant / CEO @WORK BOLD

    W:www.workbold.com| E:[email protected]| P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

    · Share on Facebook Share on Twitter
  • Richard Rymill SBP
    Richard Rymill SBP ✭✭✭✭✭✭

    Neeraj

    I presume that you are wanting to use Smartsheet for what it is excellent at, which is getting the work done collaboratively and collecting the Data outcomes, but then need to take that resultant data and analyse it/ Process it probably in Excel?

    This uses both tools for what they are good at and just needs the integration to be set up which we have become expert at.

    I will call you as you suggest and arrange a conference call. Oman is 4 hours ahead of UK which is no problem for our team who are based in the UK and USA.

    Regards

    RichardR

    · Share on Facebook Share on Twitter
This discussion has been closed.

Categories

Awesome! I'm glad it's working for you. 👍️<\/span><\/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":107147,"type":"question","name":"Using IFERROR Formula - Still getting UNPARSEABLE error","excerpt":"I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row \/ [Column2]@row --> This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an \"UNPARSEABLE\" error. I want the cell to…","snippet":"I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row \/ [Column2]@row --> This works fine However when one of the Column is a ZERO, I get…","categoryID":343,"dateInserted":"2023-06-30T16:32:54+00:00","dateUpdated":"2023-06-30T16:35:50+00:00","dateLastComment":"2023-06-30T18:58:03+00:00","insertUserID":161931,"insertUser":{"userID":161931,"name":"Christine Cao","title":"Engagement Manager","url":"https:\/\/community.smartsheet.com\/profile\/Christine%20Cao","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T18:54:01+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":91566,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-30T20:24:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":24,"score":null,"hot":3376296057,"url":"https:\/\/community.smartsheet.com\/discussion\/107147\/using-iferror-formula-still-getting-unparseable-error","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107147\/using-iferror-formula-still-getting-unparseable-error","format":"Rich","lastPost":{"discussionID":107147,"commentID":383396,"name":"Re: Using IFERROR Formula - Still getting UNPARSEABLE error","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383396#Comment_383396","dateInserted":"2023-06-30T18:58:03+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-30T20:24:17+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T18:53:59+00:00","dateAnswered":"2023-06-30T18:25:40+00:00","acceptedAnswers":[{"commentID":383387,"body":"

You need to remove the closing parenthesis from before the comma.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","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":107143,"type":"question","name":"How can I get (on a separate metric sheet) the average SLA time within a given month?","excerpt":"I am trying to create a metric sheet to document how long response and acknowledgement times are taking per month for record keeping. I have a sheet that has an acknowledgement SLA column and a \"date of request\" (auto column for when the submission was created), and I'm looking to record the average for each month on a…","snippet":"I am trying to create a metric sheet to document how long response and acknowledgement times are taking per month for record keeping. I have a sheet that has an acknowledgement…","categoryID":322,"dateInserted":"2023-06-30T15:31:46+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T17:30:08+00:00","insertUserID":159225,"insertUser":{"userID":159225,"name":"laney_white","url":"https:\/\/community.smartsheet.com\/profile\/laney_white","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5FvXObtmaHw!CVFXQvc68Xo!anynrNoWe-v","dateLastActive":"2023-06-30T17:19:19+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-30T20:48:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":21,"score":null,"hot":3376287114,"url":"https:\/\/community.smartsheet.com\/discussion\/107143\/how-can-i-get-on-a-separate-metric-sheet-the-average-sla-time-within-a-given-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107143\/how-can-i-get-on-a-separate-metric-sheet-the-average-sla-time-within-a-given-month","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":107143,"commentID":383369,"name":"Re: How can I get (on a separate metric sheet) the average SLA time within a given month?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383369#Comment_383369","dateInserted":"2023-06-30T17:30:08+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-06-30T20:48:54+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/ZXS917R2FJKC\/master-sheet-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"master sheet.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T17:19:35+00:00","dateAnswered":"2023-06-30T15:50:27+00:00","acceptedAnswers":[{"commentID":383345,"body":"

If I understand correctly, this may help.<\/p>

=AVERAGEIF({date of request}, MONTH(@cell) = 2, {Ack SLA})<\/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

  • How to get average # Workdays by Contract Type

    I'm stumped and hoping the community can help. Within Sheet Summary of my master grid, I am trying to create an average formula that calculates the average # of workdays by contract type within a specific month--in this case, June 2023. This data will be used in a Monthly Dashboard. For example: "NDA/CDA (Non-Disclosure…

  • Using IFERROR Formula - Still getting UNPARSEABLE error

    I'm calculating a Burn Rate Percentage so it's using a basic calculation FORMULA =[Column4]@row / [Column2]@row --> This works fine However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an "UNPARSEABLE" error. I want the cell to…

  • (怎么走a separate metric sheet) the average SLA time within a given month?

    I am trying to create a metric sheet to document how long response and acknowledgement times are taking per month for record keeping. I have a sheet that has an acknowledgement SLA column and a "date of request" (auto column for when the submission was created), and I'm looking to record the average for each month on a…