MichaelTCA✭✭✭✭✭✭

Hello @Simon Cowx You could use a COLLECT() function to apply multiple criteria. Here's a discussion that has answered your question. Hope this helps! https://community.smartsheet.com/discussion/98393/help-with-ranking-based-on-criteria-rankeq-collect

Interesting. There's so many quirks that can make Smartsheet very useful.

I was the first and continue to be the only who can really automate company procedures into Smartsheet. Which is ok with me! I commonly use these resources. Community Webinars Youtube Github for API When I need some deductive reasoning to the Smartsheet logic, @Paul Newcome is the person to go to. Seriously, thank you!

@Paul Newcome Did you receive the same result when another person submitted a form? Send a snapshot. Also, I do not have it require sign-in, in this example.

@Paul Newcome This is how Smartsheet references my data and unless the automation is caused by me, it's always from Smartsheet. I wish we had the "From organization" option again! That made it easy.

Hello @KevinHarrisCHT The manager must be the sheet owner and to show that it is from the "triggering user", someone will have to make a manual change within the sheet and not through a form or automation. The setting in the automation has to be set to "triggering user" as well. Changes made through automations and forms…

Hello @Samplease I understand the issue for confidentiality. The only way to restrict views but still allow editing would be through third party permissions (in this case automations) or software add-ons. You could set up an update request automation, on a scheduled or a triggered automation, that sits in their inbox until…

Hello @LauraLou, Sorry I'm a little confused as to which column(s) are we actually working with here. Are these sections in a hierarchy? You could try the AVERAGEIF() function if you want to use additional criteria.

让我们启动国家行业集团公司ht with: "Who Made Who" By ACDC "Good Vibrations Feat. Loleatta Holloway" by Marky Mark & The Funky Bunch "Walk Of Life" by Dire Straits

Definitely not up to par with my pixelated attempt. It's the thought that counts right?