Contains any text

Options

I am trying to write a formula that asks if a cell has any text (at all, not specific text), then I want to reduce another cell by 1000 if true, blank if false. This can also be achieved if it is not blank?

I have written a formula that provides a month that we have to employ a new staff member to service the growth from our pipeline when a cell (based on totalling the previous cell in the column) hits a threshold of 1000. Once we have employed that staff member, I then need to reduce the growth total by the 1000 and start the process again. This to allow us to forecast when we need to employ people ie; May, June, August etc based on the specific growth in each month.

This needs to be done this way as we have confirmed growth that we are aware of (pipeline), but we also have growth that is not in our current pipeline based on enquiry not from our established sources.

=IF([Cell??]= ISTEXT, [another cell-1000, "")

I would appreciate any guidance as I am not a skilled Smartsheet user.


Andrew

Best Answer

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Answer ✓
    Options

    Hi @andrew.taylor37161

    It would look something like this.

    =IF([cell to check]@row <> "", [another cell]@row - 1000, "")
    

    Or

    =IF(ISTEXT([cell to check]@row), [another cell]@row - 1000, "")
    


    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)


    Would that work/help?

    I hope that helps!

    Be safe and have a fantastic day!

    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 EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!