Sign in to join the conversation:
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])
We want to implement single-sign-on at work and have received approval. However, our IT department wants all external partners to have/use Mayo credentials to log into Smartsheet. Not all of our external partners ever set foot on our campus and don't have our company credentials. I have a couple of questions. Has any other…
I can create a Chart in Dashboard from sheet well but from Report is not working now. I just try with simple Report (just contain 2 column Primary and Number) but cannot make the chart. Is there any changes recently right, because I haven't worked with Smartsheet dashboard for a long time and I remembered that I could do…
Cant find this anywhere
