Contains any text

andrew.taylor37161

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

Andrée Starå

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!

Andrée Starå

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!

andrew.taylor37161

Andrée you are a Starå!

Worked like a charm. Thanks for your help. I hope you stay safe and I am now having a fantastic day because of your help.

Andrew

Andrée Starå

@andrew.taylor37161

Excellent!

Thanks for the compliment!

https://media.giphy.com/media/lszAB3TzFtRaU/giphy.gif

You're more than welcome!