Best Of

Thank you! I did not realize you could just make a report rather than complicated formulas to do the work (like I've seen on the Youtube videos that I've been using). This makes my life so much easier 😁

@megtro610 Try this formula if you are having issues with that. If you are looking at counting all them I would suggest copying what you do for level 2 and do an open and closed for each level. Then when you go to add the pie chart you would highlight all the metrics that you want in that particular chart.

For closed:

=COUNTIFS([Level]:[Level], "2", [Closed?]:[Closed?], 1)

For Open:

=COUNTIFS([Level]:[Level], "2", [Closed?]:[Closed?], 0)

See below screen show on how I set up the information for pie chart. You have to have a column for the name of what you are trying to compare to:

Hi @Isis Taylor all of those security options are toggled off. I actually just figured out how to disable that message to download the app, I think you and I were typing at the same time, LOL!

You have to turn off the Smartsheet footer. I toggled with the footer and saw that this made the difference. 😀

Thanks for your willingness to help!

Hello @James Preston,

There is a way to achieve this. Go to Edit your form and click on the column where you want a numerical value. On the right side under Field Settings, scroll down to Validation and select Number only. I would also add "Help Text" stating, "apply only the numerical value on the form e.g. 80". Then save the changes.

Next, go to your sheet, click on the column with the numerical value, then click the three dots (near Share in the upper right corner), and select $, then the applicable currency.

Hope this helps!