jacquedale✭✭✭✭

@NavyPilot I know its frustrating...this seems like a pretty simple adjustment. But here is a previous comment I made regarding this: I have requested this feature previously as well. I know it is a pain point for many of us. At Engage last week I spoke with tch support and I was told about the use of "groups" in the admin…

Thanks for all of the input. I was never able to figure out the problem on my own but I spoke to tech support at Engage last wee k and we finally identified that it was happening only when I performed the "run now" check on the whole document. So I had to add an additional condition

I have requested this feature previously as well. I know it is a pain point for many of us. At Engage last week I spoke with tch support and I was told about the use of "groups" in the admin center. This is actually a great work around for this "lack". If you set up your various groups and share a given sub-folder to that…

So excited to learn more ways to put Smartsheet to work for our company!

@AravindGP You are a life saver! This worked perfectly. Thank you so much.

Got it! I was doing it backwards. Once I changed it to "open" as the first criteria and then the contractor it worked!. Thank you for your help @Paul Newcome =COUNTIFS({QAR KPI Data Range 4}, "open", {QAR KPI Data Range 3}, labels@row)

That isn't working either. That gives me a count of "0" even when there is "1"

Ugh, LOL I knew it was something simple I was overlooking. @ShelbyWarren That did the trick thank you. Its already been one of those weeks.

allow for an easy way to setup booking feature within the form. My field teams allow contractors to scheduled desired dates/times for inspections however I am having to build a complex work around instead of a simple booking addition that would eliminate options as they are selected.

I was able to get into the admin center, but I don't have a permissions listing specifically for "forms" as you shared. Here is what mine looks like.