Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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])
Hi, I am wondering if there is a solution for this scenario: I have a Data Shuttle data upload workflow to a Target Sheet that is updated when a new attachment is added. Question: is there a function/features/workaround like Data Shuttle, Bridge, or a combination of features so that if a new column is added to the Excel…
I have downgraded to business but no longer have access to my sheet,i get an error 48,get licensing? How do I fix this? This is a customer contact form so i cant recreate it as the email has been sent?
I have been given access as an Admin to edit an existing sheet but cannot edit columns. I am a System Admin. I am a paid Member. I am able to edit information in the sheet but cannot add a column.
