SEAN WILLIAMS

[email protected]’s Profile

Community member since August 2018

points
230
Company
BLU SKY TECHNOLOGIES
Area of expertise
Apps/Integrations
About Me
Hello!

I'm based near Sydney, Australia working almost exclusively on Smartsheet based solutions and apps particularly those that require automation or integrations to other services.

Feel free to contact me - [email protected] with any Smartsheet related challenges that you are facing.

3

Can someone show me how to use a VLOOKUP for the highest value?

For example:

=VLOOKUP(LARGE([% of Target]1:[% of Target]16, 3), Name1:[% of Target]16, 2)

 

Basically by the LARGE([% of Target]1:[% of Target]16, 3) I am returning a value of 52% (which is the third highest value). This is automatic.

4

I'm using Data Mesh to try to keep the records in a report synchronized with a target sheet.  It seems to be working for adding new records to the target sheet and for updating existing records in the target sheet.  However, if a record is removed from the source, I need to have it removed from my

5

Similar to my previous post, I'm now running into issues with CountIfs returning zeros when I am referencing multiple columns from a separate sheet. I am trying to figure out the number of "Risks" and "Issues" that are marked as state "Complete" each week. I was able to count how many risks and