-
Create a formula to calculate the price of comma delimited items in 1 column.
I have a vendor registration form that connects to Smartsheet from Google Forms using the Smartsheet Add on for Google Forms. When completing the registration form, the vendors can select up to 4 tables to rent and each table may have a different price. The form automatically created and populates my Smartsheet with the…
-
Merged: Allow for column grouping
This discussion has been merged.
-
Multi-worksheet excel linked to template for each worksheet?
Sorry, I'm new to SS but trying to see if we can use a single template to build access to dashboard for each worksheet in excel (about 30 worksheets in single file). Ideally, we want to be able to see each dashboard without opening a different file, either by tabs or scrolling screens. But I can't find anyway to do it some…
-
Sheet Column for Missing Attachment
Hello, I'm pretty new to creating functions for columns and wanted to see if there is a way to have a Missing Attachment column displaying Yes or No depending on the attachments themselves for the row? It seems like the attachment "paperclip" itself can't be leveraged as a filter in the Work Insights graphs. Thanks! Jim
-
Enable Autosave for Published Sheet (edit by anyone)
I have several sheets whose sole purpose in Smartsheet is to live on a dashboard as published web content and provide a dropdown with names. When the name is selected, it brings up a link to a form URL with the name information URL queried into it. After the link is clicked, a new name is picked from the dropdown to…
-
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…
-
Merged: Move/Add row automation: The ability to choose if the row populates at the top or bottom of…
This discussion has been merged.
-
Log in needed in Microsoft Teams to access sheet not working
I just got Smartsheet integration with Microsoft Teams set up, and yesterday it was working beautifully, being able to see and edit the sheet within Teams. Today when I opened Teams, it's asking me to log in to smartsheet, taking me to my brower. When I do, nothing happens in Teams. When I refresh the tab in teams, it's…
-
Can you cell-link within the same sheet?
My team is tracking product development for a project and we want to be able to reference multiple rows within the same sheet. For example, in row 20 we want to have a column labelled "Refer To" and then in the cell, have a link that takes the user to row 100, 140, or 170. I know you can cell-link to other sheets in a…
-
The ability to omit blank fields in email notifications
When sending alerts and requests through automation, we currently have the option to send a message including either all fields, specific fields or the message only. For my particular organisation(and i would imagine many others), none of these options work. We have dynamic forms that build themselves based on answers and…
