-
Nested CountIf statement help needed
Hi, I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline)) I'm not sure exactly what…
-
Web Form Unable to be Accessed
Someone who we've asked to supply feedback via web form received this message: "The form you are attempting to access is no longer active." We have not deactivated the form. The "Deactivate" choice under the "More" option is there. Is this possibly a firewall/security issue on the user's end?
-
Custom Template
Hello, I'm looking for a SmartSheet expert to build out a custom Project & People KPI report template, I know what I want to the end result to looks like but I would rather work with someone that I can share my vision and they can use their expertise to make it happen. Let me know if you would like to have a conversation…
-
Web Form Google Chrome Dangerous Warning
Hello Community, Our Web Form URL has been falsely reported to Google as a dangerous website. When visiting a Web Form from within Google Chrome, you'll receive the error below that Gwyneth posted. We have reached to Google to rectify the situation. In the meantime, users can bypass the Google security warning by clicking…
-
O365 Integration for unlicensed users
We have a Business plan with 15 licensed users, then will invite perhaps another 100 collaborators (unlicensed users) as part of the various projects across enterprise. All same organization. We are an O365 shop and have integrated all licensed users with O365. However, there does not appear to be anything but a static…
-
Comments in Sights
Is there a way to pull comments into a sight? I am new at this and trying to create a dashboard and was hoping to use the comments field and pull it into the dashboard. I have tried to do it straight from the metrics widget but it won't let me select any comments. I have also tried to create a report but it doesn't…
-
Report Builder "What?" with multiple criteria
I am trying to create a report to find all tasks that are not checked as done or does not have a status of Complete. See the attached screen shot -- what am I doing wrong? I have 88 items in the list; there are 5 where Done is checked; there are 7 that are marked 'complete. That means when I run the report, I should have…
-
Field Labels in Card View?
Hello Smartsheet Community! I have just started working with Card View, and I was wondering if it is possible to have Field names display in the Cards as a label, in addition to the actual content of the cells? So for example - if I have multiple Fields display on the cards that have similar content (Ex: Yes/No, Dates,…
-
Comments Report
Hello, Is there a way to get a report of all the comments that have been entered a give week for a given user? Thank you, Lisakay
-
Clarity needed on using the contact list column type in a form
Hi all, Seeking clarity on the contact list column type for a form we use to have information submitted to our team by other employees. What I would like to end up with is a sort of "automated" contact list that pulls every name on our Enterprise account. Is that a possibility? The biggest issue for us and using forms to…