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:
Id like to summarize status for a list of users involved on multiple project checklist. The dashboard function tells me I can only use numerical data in reports/widgets. Is there something I am missing? I want to provide a quick glance at overall status of multiple checklists.
Hello,
Your data needs to be aggregated and calculated in a sheet first.
You'll want to create a function that counts these values, such as COUNTIF or COUNTIFS.
Then, you can use a metric widget to bring in the counted values.
More information on these functions is available on our functions page: https://help.smartsheet.com/functions
I have two sheets that use the exact same workflow: Trigger: When rows added/changed When checkbox - checked Send to contact in a cell Then record date In one sheet the workflow works as intended. In the other, the workflow appears to work (date is recorded) but no notification is received. I have already confirmed that…
Hello. I am currently making a form to track events associated with current locations. These locations will be referred to by their unique, 5 digit ID; however, this form will be used by many different people in and outside the organization, so I would also like to display the physical location so people can double check…
I have build a email validation in my sheet where entered emails from a form are entered in a contact field. another field verify the address and validades using the following formula: =IF(FIND("@xxxxxxx.com", [Student eMail]@row) = 0, 0, 1) if the checkbox is triggered (=0), then the registration is valid, and the the…
