Welcome!

Average

I have a column " Resolved on Request Date" with a "Yes" or "No"

How can I get a average number of yes replies and an average number of no replies.

I want to be able to create a Dashboard on the information.

THanks,

Try the following formulas to calculate the average of Yeses

=COUNTIF([Resolved on Request Date]:[Resolved on Request Date], "Yes") / COUNT([Resolved on Request Date]:[Resolved on Request Date])

Try the following to average the No's

=COUNTIF([Resolved on Request Date]:[Resolved on Request Date], "No") / COUNT([Resolved on Request Date]:[Resolved on Request Date])

Conditional Logic in Forms
I’ve started building a form in Smartsheet using the Smartsheet Form Builder, and the responses are successfully populating my sheet. The challenge I’m running into is creating conditional logic within the form to narrow down selections. For example, if a user selects a state (such as Florida), I’d like the next question…
Published calendar view not showing all tasks
When I publish the calendar view, not all my tasks are showing up. I have all filters off. In my regular view on the sheet, the tasks are there.
Creating a folder in SharePoint from Smartsheet and naming it based on row data
I'm a Power Automate Novice and I'm not experienced in expressions. I am building a data flow in Power Automate to create a new Sharepoint folder when a new row is created in my smartsheet. I can get to the stage of creating a new folder however I would like to name it based on cell data in the row. I have tried to use the…