I have tried the formula in office and it works fine, but not in smartsheet, why is that? It doesn't show no match or any other error, but it doesn't show the correct result!!!!!!!
😥help me please!
Try editing Type@row to be [Type]@row and Value@row to be [Value]@row.
Everything else looks accurate.
thank u so much, but after I edited, nothing changed😥and when I reopened the formula, [type]became type again
What error do you get?
If this is a column formula, it could be:
You're using Match([Value Threshold(EUR)]1 instead of Match([Value Threshold(EUR)]@row
It could also be that the cross-sheet reference isn't liking that you have brackets in the references name:
[Value Threshold(EUR)]1 vs [Value ThresholdEUR]1
Can you provide a little more detail about the issue/error message?
this is the same formula that works correctly in the Office, on Smartsheet, the only difference is: the data source is from another sheet. The column, now, cannot show the correct answer without mentioning like: REF/No Match
Hmm, this is tough to say what the issues is without seeing how you have your cross sheet references set up.
Here is a couple things to check:
Have you tried changing the formula to exact matches and seeing if that gives you the correct result?
Also, if you have a formula calculating the value, make sure you don't have an iferror changing the value to blank, this can cause havoc in dependant if statements.
Check that your index and match reference columns are selected in the correct order, and only referencing one column per index and match.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I have a list of action items that can be assigned to several departments by using a multiple drop down list with dept. names in the assigned column I am trying to create a summary sheet to count the number assigned I have tried both Contains & HAS But my answer is 0 - Just using the count if gets me 23 and there are 2…
Hello! I have not written formulas in quite some time, and need some help. I want to check the "Most Recent" box, if it is the most recent submission for that workstream.
Hi Guys, I am looking for the formula to return value for a cell which is in the range. I have one smartsheet like above in the second smartsheet I have cell with date and for example if I have there 08/02/24 I want formula to give back Q3 FY25. Any ideas how can achieve this?
©2024. All Rights Reserved Smartsheet Inc.