-
Count "Red" symbols in Sheet Summary
Hi all, New to Smartsheet and wondering how I get my sheet summary to count the number of "Red" symbols for status reporting. Understand that COUNTIF won't count symbols from what I have read. Does anyone have a way around this? Thanks in advance.
-
Changing the "Contact" function (Global Variable Please?)
Salutations, Presently, I am attempting to generate a productivity report regarding employee projects and workflows. I have utilized the Contact feature, as I'm only tracking/assigning tasks for Management level. No other users will use this or see it. However, we are unable to presently store sheet-specific data, as…
-
Easy way to express Monthly Data
Hi all, I have started a project to use Smartsheet to track Right First Time across several departments. As part of this I want to track the data on a monthly basis. The form uses a 'Created date' field to input the date when the entry was submitted. Is there a way of expressing the date, so I can use it as a COUNTIFS…
-
Tool sign in and out
I am looking to create a sign in and out process for tools. My thought is that employees will be able to fill out a form and scan a barcode on each tool to identify what tools they are signing out. Then once returned will be able to scan the barcodes again to sign the tool back in..... Hope that makes sense and looking…
-
Card View: Limitations on how much text can be displayed on one line, etc.
I have noticed there are some confusing limitations imposed on the desktop version of smartsheet that are not on the mobile. I have one primary concern to focus on: When I am on desktop, card view does not display any more than one line of text before adding an ellipsis (...). Why is it limited like this on desktop but not…
-
Build Report that shows "Child" lines items under the "Parent
I am trying to build a report from a sheet that has a parent line item with child line items. I need the report to show the parent and the child. Then have the ability to group by the parent. When the parent is expanded it shows the children. My report currently looks like this...all the indented child line items are no…
-
can a person submitting a form save it if they need to come back to it later?
I have created a form that requires a lot of information before it can be submitted. The person completing the form may not have all the information at hand or may get interrupted while completing the form. Is there a way the person can save what has been entered so far and come back to it later? Is the only to keep the…
-
Trying to convert a form to smartsheet and having problems
Hello and Thank You in advance for any guidance you may be able to provide. I'm trying to convert a form that i use to track FTE changes into smartsheet. What I need to have is a section that allows for multiple responses for each type of FTE (Admin, Clinical, Educational or Research) some that might be the same (for…
-
Report Names, Dashboard Titles and Widget Names with non-static strings
The name of reports, dashboards and widgets are limited to static strings, so the user will only know the name of the report and not what information is in the report. Example: The External Appeals Report title cannot be automatically updated to Q1 2022 External Appeals Report. Having automated strings based on the report,…
-
Proofing Download Not Working
Hello, I have a sheet with Proofing enabled. When a proof is sent to a reviewer with the allow download option enabled, the reviewer is unable to download the proof. When download is attempted, a new page opens up with an error message that says, "This link has been removed or cancelled." How can this be fixed? Thanks, Dan
