IFERROR(VLOOKUP help

ealexis ✭✭

Hello,

Can someone please help me if a vlookup formula

This is what I have,

=IFERROR(VLOOKUP([Student ID]@row, {IDsheet}, 1, false), "Not Found")

But I also want to include another category that must be check before the answer comes back from the same IDsheet

0 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Subtract 1 month from the date expire for a task
I have a column that calculates a due date that uses this simple formula: =DATE(YEAR([Date Expired]@row), MONTH([Date Expired]@row) - 1, DAY([Date Expired]@row)) It works great but for some reason returns #INVALID VALUE when the date expired is any day in January. any other month seems to be fine I'm guessing because the…
Count(Distinct(Collect Help
Hi All, I'm trying to count the number of 'distinct' participant to events based on the year and add that count to their org leaders. In the table where I have the participant I've alredy added helper columns to identify their leaders at different lvl. My formula works fine as long as I point to the specific column where I…
Formula for Index/Match Multiple Criteria
Can someone help me with an Index/Match or Index/Collect formula to accomplish the following logic? When {ArchiveCSYYXXXX} = CSYYXXXX@row AND {Task} = "Final Signed", provide {FinalSignedDate} In case it's relevant {ArchiveCSYYXXXX} and {Task} are child rows on their sheet. Thanks so much in advance!