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.
Andrew
Best Answer
-
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
-
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.
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!