You’re offline. This is a read only version of the page.
Announcements
I have a condition where I am comparing an excel sheet to an output and then double-checking it from the excel sheet to their Outlook profile but for some reason, the condition keeps getting marked "False" instead of true. Screenshot is below but the outputs are:
Last Name Excel: PITT
Output: PITT
Emp #: 9292
Nickname: 009292
Hi @Anonymous ,
From the data you provided, the correct conditions should be Nickname contains Emp #.
In addition, if they are used as strings for comparison, then you need to ensure that both values are string or format these two values into string format using the string() function, so that you can use Contains to determine.
You can swap the positions of Nickname and Emp # first and then test if the results are as expected.
If it still doesn't work, you need to format them into strings using the string() function before you can compare them.
Like:
Best Regards,
Share
Report
All responses (
Answers (
538
