Jgorsich
Jgorsich
Reactions
-
Re: IF Row @ Column A=Column B, then return Column C
Try =INDEX({SheetBServices}, MATCH([SheetA Order ID]@row, {SheetB Order ID}, 0)) Basically, the index function you already tried looks correct EXCEPT you want to index through your services column no…2 · -
Re: IF Formula assistance.
You could simply wrap the whole think in another if statement that forces a 0 if the start date is greater than today(). That would likely be the simplest.2 · -
Re: Formula using Index and Match to reference another sheet only returns first item
The last argument is for how the lookup column is sorted - unless you are specifically trying to take advantage of that (with maybe saying "find the last dollar value before this specific price&…1 · -
Re: Can I Import a Large Excel Sheet with Embedded Formulas into Smartsheet?
Given that the formulas in Smartsheet work fairly differently than those in Excel, and that there are MANY functions that Excel has that Smartsheet has no equivalent for, I can't imagine you could im…1 ·
