If Index Match
Options
Karrie Davis
Overachievers Alumni
Hi,
I'm trying to figure out the due date for a submission if the dates remaining is >0 below is the formula I came up with, however it is not working.
=IF(INDEX({Due Dates}, MATCH([Client Matter]2, {Client Matter #})), {Days Remaining}, @cell > 0)
Also, is there a way to do an Index Match or vlook up that gives me the entered
Tags:
Comments
-
I'm not sure I follow. The formula you posted unfortunately doesn't shed much light on the issue.
Can you describe the process and desired outcome in more detail and maybe share some screenshots with sensitive/confidential data removed, blocked, or replaced with "dummy data"?
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!