Contains any text
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.
Help Article Resources
Check out the Formula Handbook template!