Flag when a character is entered instead of a number =IF(NOT(ISNUMBER statement...
Hello,
I cannot figure out how to add in 2 other cost fields into this statement. My purpose is to have 1 check box (in a single column) enabled with a check mark, whenever one puts text into a field where we need only numbers. The field names are : Travel Cost, FTG Cost and HS Cost. Once I get this part done, I will then setup a notification back to the user to resubmit a new form using numbers.
I was able to get only 1 column to work, but I need to add 2 more. What is the formula, please and Thank you!
=IF(NOT(ISNUMBER([Travel Cost]@row)), 1)
Answers
-
Hi @GetITDone
You need to add an OR function.
=IF(OR(NOT(ISNUMBER(Travel Cost]@row)), NOT(ISNUMBER([FTG Cost]@Row)), NOT(ISNUMBER([HS Cost]@Row))), 1, 0)
This will check the box if any cell is not a number.
Hope it helped!
-
Hi @GetITDone
To add to David's excellent answer.
Here's another option.
Try something like this.
=IF(COUNTIF([Travel Cost]@row:[HS Cost]@row, ISTEXT(@cell)) > 0, 1)
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 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.
-
Nice one @Andrée Starå . I often forget that range can be done within a row.
-
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.
-
Thanks everyone.
For some reason I couldn't get this one to work for 4 'costs' columns within a short period of time. What would it look like if I have Travel cost, HS Cost, FT Cost and GT cost?
=IF(COUNTIF([Travel Cost]@row:[HS Cost]@row, ISTEXT(@cell)) > 0, 1)
So I used below, My only concern making sure I do not move any columns around as it will pick up unnecessary costs.
=IF(COUNTIF([Travel Cost]@row:[HS Cost]@row, ISTEXT(@cell)) > 0, 1)
What would it look like if I have Travel cost, HS Cost, FT Cost and GT, how to make it specific columns? Thanks
-
Happy to help!
Not sure I follow!
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
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.
-
Hi Andree thanks for your help. I can get that to you this week.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!