Is there a formula for what I have described below?

04/21/21
Accepted

I want to add or subtract a row in a separate column when another column’s row has data. Basically I have a master column that houses certain numbers one being 46. I have other columns that are name Date item added and Data item removed (Date). My goal is that when someone adds a date in a row in the add column, the master row would add 1 and become 47. When someone adds a date to the remove column, the master row would subtract 1 and become 45.

Best Answer

  • Accepted Answer

    Thanks for sending that formula, even though it did not work I was finally able to get the results I needed, just had to go another route. I could never get the results in one formula, so I broke it down into two: =[Master ]4 + COUNTM([Date W Added]:[Date W Added]) and then =[Master]7 - COUNTM([Date W Removed]:[Date W Removed])

Answers

  • Bassam KhalilBassam Khalil ✭✭✭✭✭

    Hi @Richard Trader 

    Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    Best Regards

    Bassam.M Khalil


    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful". 

  • @Bassam.M Khalil please see the attached screenshot.


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

    Hi @Richard Trader

    I hope you're well and safe!

    Try something like this. (Primary would be starting amount)

    [email protected] + COUNT([Date W Added]:[Date W Added] - COUNT([Date W Removed]:[Date W Removed]))

    Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

    Did that work/help?

    I hope that helps!

    Be safe and have a fantastic weekend!

    Best,

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

    Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

  • Accepted Answer

    Thanks for sending that formula, even though it did not work I was finally able to get the results I needed, just had to go another route. I could never get the results in one formula, so I broke it down into two: =[Master ]4 + COUNTM([Date W Added]:[Date W Added]) and then =[Master]7 - COUNTM([Date W Removed]:[Date W Removed])

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

    @Richard Trader

    Excellent!

    You're more than welcome!

    Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

Sign In or Register to comment.