Hi,
is it possible to capture the amount of entries that have come in from a form? the form is constantly being populated so i am looking for a live number if possible?
Any help appreciated.
thank you Dave
Hi Dave,
Yes, it is. You can add a column (that you can hide) and a field on the form that you hide and set to a default value like submitted form or similar.
Edit. You can then use a count formula to get the total number.
Would that work?
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Hi Andree,
thank you for taking the time to reply. I am not quite sure what you are suggesting?
What i need to do i provide an ongoing figure to my customers dashboard of how many entries have been made against a particular form?
So this number would be constantly updating, how would i add a constant count to then display on the dashboard?
Sorry probably being a bit slow and its probably easy
Thank you again for taking the time to reply
Dave
You could use the COUNT function to count all the cells that ain't empty and then show that on a dashboard with a metric widget.
Andrée
i don't think it will unfortunately. i have set a field to give each entry a numeric value which shows me the amount of entries but i cant get the dashboard data to read the latest value.
Regards
Can you share the sheet, workspace or some screenshots so that I can get a better understanding of your set up?
Hi Andree
how do i share with you? more than happy to let you take a look, havent figured out how to get screen shots on here but happy to share.
You can share the sheet or workspace with me at andree@getdone.se
If there is sensitive information, you could share a copy instead.
Try this.
If I understand you correctly this is the formula that you should use in the cell for the count on the summary sheet.
The Anomolies Range 1 is for the Row ID column, and you need to select the reference in your sheet.
The formula will count all the cells that are not empty.
=COUNT({Anomolies Range 1})
Works perfectly,
Thank you for taking the time to have a look at this,
Hi all, and thanks in advance! I wanted to know if there was any way to create "padding" in Smartsheet. Basically I have account numbers, and a handful are still 2-digit, so they appear as TDL-17, TDL-67, etc. Most of the accounts are 3-digit numbers like TDL-180. I want something that will recognize whether it is 2 or 3…
I'm wondering if anyone has worked out a dynamic formula to return the date of the 'next' Thursday of the month. I have a worksheet where I need to send out a reminder to a contacts in a contact column in the worksheet each Thursday of the current month if a criteria has not been met. When criteria has been met, then…
Hello, I have the formula to check a box for line items with the current month. =IF(AND(YEAR(Date@row ) = YEAR(TODAY()), MONTH(Date@row ) = MONTH(TODAY())), 1, 0) Trying to set up a report for all items with the previous month (i.e. 1 month prior to current). How can I modify to check the box?